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: 68624
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: Thu Mar 28 10:27:26 CDT 2024