| Re: Oracle error message [message #371879] |
Mon, 18 December 2000 03:40 |
John R
Messages: 156
Registered: March 2000
|
Senior Member |
|
|
As with all things, the answer depends on what exactly you mean, and why you want to know.
Errors generated by compilation of server side code are visible from the views User_Errors and All_Errors (and Dba_Errors if you can see that)
If you mean 'Where are the definitions of the ORA-????? messages stored, I don;t know (but if you find out, do please post something telling us all)
If you mean 'How can I add my own errors to the system' the two main tools are:
1) Declaring exceptions in package specifications using the Pragma Exception_Init, which creates new exceptions that can be raised
2) using Raise_Application_Error
er Raise_Application_Error('-20043','Hovercraft Is Full Of Eels') which will produce the output:
ORA-20043: My Hovercraft Is Full Of Eels
Hope this helps.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
