Home » Developer & Programmer » Designer » : when others probs thanks but some more clarification
: when others probs thanks but some more clarification [message #90440] Mon, 22 September 2003 08:56 Go to next message
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 Go to previous message
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..

Previous Topic: when others probs
Next Topic: which is the beter way to design a database
Goto Forum:

Current Time: Sat Jul 31 06:51:43 CDT 2021