Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL (Exception)
PL/SQL [message #301652] Thu, 21 February 2008 04:30 Go to next message
kr_arvind
Messages: 85
Registered: April 2006
Location: Delhi
Member
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 ?


Arvind
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
  end;
  begin -- block2
  .
  end;
end;
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.

By
Vamsi
Re: PL/SQL [message #301659 is a reply to message #301652] Thu, 21 February 2008 04:50 Go to previous message
Michel Cadot
Messages: 64119
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

Regards
Michel
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 Dec 06 10:05:14 CST 2016

Total time taken to generate the page: 0.08676 seconds