OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL (Exception)

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

PL/SQL [message #301652]

Thu, 21 February 2008 04:30

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

Report message to a moderator

Re: PL/SQL [message #301654 is a reply to message #301652]

Thu, 21 February 2008 04:37

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

Re: PL/SQL [message #301659 is a reply to message #301652]

Thu, 21 February 2008 04:50

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 17 04:27:57 CDT 2025