OraFAQ Forum: SQL & PL/SQL » Exception Handling

Home » SQL & PL/SQL » SQL & PL/SQL » Exception Handling (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exception Handling [message #652788]

Mon, 20 June 2016 01:38

Satheesh.A
Messages: 9
Registered: May 2016
Location: Chennai

Junior Member

If we have both user exception and system exception, which will be handled first?
Tried searching online, couldn't get proper explanation.pls help

Report message to a moderator

Re: Exception Handling [message #652790 is a reply to message #652788]

Mon, 20 June 2016 02:22

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Can you explain your question.

And give feedback to your previous topics.

[Updated on: Mon, 20 June 2016 02:23]

Report message to a moderator

Re: Exception Handling [message #652791 is a reply to message #652788]

Mon, 20 June 2016 02:39

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

The one that happens first.

Report message to a moderator

Re: Exception Handling [message #652792 is a reply to message #652791]

Mon, 20 June 2016 02:52

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Please explain the context of your question.
Why do you want to know?

Report message to a moderator

Re: Exception Handling [message #652797 is a reply to message #652792]

Mon, 20 June 2016 03:01

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

As pablolee says - the one that happens first. As soon as an exception occurs execution stops and the code jumps to the first exception handler it can find that can handle that error.

Report message to a moderator

Previous Topic:	LAG function
Next Topic:	Aggregate based on serial number after checking for thresholds

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 14:07:25 CDT 2024