| Exception [message #85398] |
Tue, 22 June 2004 20:31  |
amit goel
Messages: 20
Registered: March 2004
|
Junior Member |
|
|
|
I want to know where we use Pragma Exception_Init and where we use user defined Exceptions. How we can come to know which exception we should use.
|
|
|
|
| Re: Exception [message #85403 is a reply to message #85398] |
Tue, 22 June 2004 23:43  |
Tak Tang
Messages: 142
Registered: May 2004
|
Senior Member |
|
|
|
Normally, we define, raise and catch our own errors. Pragma Exception_Init allows us to catch and handle oracle errors through the use of exception handling. All it does is associate an error number with a named exception. You can find the error number in the Oracle Server Error Messages guide, and give them any name you want - although exceptions with the same number count as the same exception. Some common ones have been predefined - NO_DATA_FOUND; PRORAM_ERROR etc... you can find a list of these in the PL/SQL guide.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
