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: 2108
Registered: October 2003
Location: Hyderabad, India
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: 65143
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: Fri Aug 18 19:09:50 CDT 2017

Total time taken to generate the page: 0.22186 seconds