| : when others probs thanks but some more clarification [message #90440] |
Mon, 22 September 2003 08:56  |
Prasad Kumar
Messages: 4
Registered: August 2002
|
Junior Member |
|
|
Thanks satish for the reply.
I just want to know Will the code compile if we place the exception when others in between the exception calls and not at the last.
And what will happen to my code will the raised exception go into when others ot myexception handle
kindly reply soon
|
|
|
|
| Re: : when others probs thanks but some more clarification [message #90441 is a reply to message #90440] |
Tue, 23 September 2003 01:03  |
R.Satish Kumar
Messages: 14
Registered: August 2003
|
Junior Member |
|
|
Hi Prasad,
If you place when others exception in between other
exceptions then oracle will throw
(PLS-00370: OTHERS handler must be last among the exception handlers of a block )
error. When others should be last exception as it
handles unexpected exceptions which are not been
captured by the other exceptions..
If you raise the user defined exception based on some criteria and if it is met, then it executes the action defined under the userdefined exception. And if not by any other exceptions then when other exception is been called..
Rgds,
Satish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
