Home » SQL & PL/SQL » SQL & PL/SQL » Exception Handling (oracle 11g)
Exception Handling [message #652788] Mon, 20 June 2016 01:38 Go to next message
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
Re: Exception Handling [message #652790 is a reply to message #652788] Mon, 20 June 2016 02:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68053
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 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
The one that happens first.
Re: Exception Handling [message #652792 is a reply to message #652791] Mon, 20 June 2016 02:52 Go to previous messageGo to next message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Please explain the context of your question.
Why do you want to know?
Re: Exception Handling [message #652797 is a reply to message #652792] Mon, 20 June 2016 03:01 Go to previous message
cookiemonster
Messages: 13894
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.
Previous Topic: LAG function
Next Topic: Aggregate based on serial number after checking for thresholds
Goto Forum:
  


Current Time: Tue Dec 07 13:12:38 CST 2021