WHEN OTHERS Exception [message #347777] |
Sat, 13 September 2008 21:36  |
prachi.mgorwadkar
Messages: 75 Registered: May 2007 Location: Pune
|
Member |
|
|
Sir,
If, I have WHEN OTHERS exception in my block, and while processing my program, I get any non-Oracle Exception.
Will that non-Oracle exception get trapped in OTHERS exception?
My answer is NO, as OTHERS will only handle Oracle definewd exceptions or the non-defined Oracle exceptions. It will not handle non-Oracle exceptions like Form's Error messages or the User-defined messages.
But I just want a confirmation for this answer.
Thanks and Regards,
-Prachi G.
|
|
|
|
|
|
|
Re: WHEN OTHERS Exception [message #347802 is a reply to message #347777] |
Sun, 14 September 2008 01:59   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
prachi.mgorwadkar wrote on Sun, 14 September 2008 04:36 | Sir,
If, I have WHEN OTHERS exception in my block, and while processing my program, I get any non-Oracle Exception.
Will that non-Oracle exception get trapped in OTHERS exception?
My answer is NO, as OTHERS will only handle Oracle definewd exceptions or the non-defined Oracle exceptions. It will not handle non-Oracle exceptions like Form's Error messages or the User-defined messages.
But I just want a confirmation for this answer.
Thanks and Regards,
-Prachi G.
|
Define non-Oracle errors within a PL/SQL block.
WHEN OTHERS catches each and every error that can occur during the execution of the PL/SQL block it handles.
|
|
|
|
Re: WHEN OTHERS Exception [message #347807 is a reply to message #347803] |
Sun, 14 September 2008 02:17  |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Reread my reply:
You keep mentioning non-Oracle errors. Give me an example of a non-Oracle error that can occur in a PL/SQL block.
Not some vague example like 'a Forms error', but a concrete description of what can go wrong.
|
|
|