Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL (Exception)
PL/SQL [message #301652] Thu, 21 February 2008 04:30 Go to next message
Messages: 85
Registered: April 2006
Location: Delhi
Hi All,

If PL/SQL Block one though the exception then next block is executed in the procedure or not, if yes please guide me how ?

Re: PL/SQL [message #301654 is a reply to message #301652] Thu, 21 February 2008 04:37 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Is the exception handled in the first block or not?
Is the code like the following?
begin --outer 
  begin -- block1
  --code to throw exception
  begin -- block2
If the inner block doesn't handle the exception, then it will throw to the outer block, not to the next block.
Next time, give the example and ask the question.

Re: PL/SQL [message #301659 is a reply to message #301652] Thu, 21 February 2008 04:50 Go to previous message
Michel Cadot
Messages: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database PL/SQL User's Guide and Reference
Chapter 10 Handling PL/SQL Errors
Section How PL/SQL Exceptions Are Raised, How PL/SQL Exceptions Propagate

Previous Topic: log miner is not displaying the result in text format
Next Topic: Problem to run store procedure - ORA-01008: not all variables bound
Goto Forum:

Current Time: Tue Oct 25 13:20:48 CDT 2016

Total time taken to generate the page: 0.05061 seconds