Home » Infrastructure » Unix » Error Exception Handling from SQLPLUS to PL/SQL
Error Exception Handling from SQLPLUS to PL/SQL [message #285800] Wed, 05 December 2007 12:30 Go to next message
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?
Re: Error Exception Handling from SQLPLUS to PL/SQL [message #285801 is a reply to message #285800] Wed, 05 December 2007 12:35 Go to previous message
Michel Cadot
Messages: 59142
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
Previous Topic: Trouble compiling external procedure.
Next Topic: How can I do to start Oracle in Solaris automatically?
Goto Forum:
  


Current Time: Fri Sep 19 05:51:43 CDT 2014

Total time taken to generate the page: 0.23345 seconds