OraFAQ Forum: Unix » Error Exception Handling from SQLPLUS to PL/SQL

Home » Infrastructure » Unix » Error Exception Handling from SQLPLUS to PL/SQL

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

Error Exception Handling from SQLPLUS to PL/SQL [message #285800]

Wed, 05 December 2007 12:30

MochaTechie
Messages: 1
Registered: December 2007

Junior Member

I have a unix shell script using the whenver sqlerror exit ....clause in calling a pl/sql procedure. In the procedure I have an exception handler.

Question is will the unix shell script capture the error that I am handling or do I have to put in a raise clause in the exception handler to push it back to the sqlplus environment?

Report message to a moderator

Re: Error Exception Handling from SQLPLUS to PL/SQL [message #285801 is a reply to message #285800]

Wed, 05 December 2007 12:35

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you don't raise the error in your exception block then it does no more appears in outer blocks and caller.
Exception block means you handle the exception, so it no more exists.

Regards
Michel

Report message to a moderator

Previous Topic:	Trouble compiling external procedure.
Next Topic:	How can I do to start Oracle in Solaris automatically?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 19:22:00 CDT 2023