Error handling
From: Nick Van Ermengem <ermengen_at_realsoftware.be>
Date: 1997/05/09
Message-ID: <337340dd.32303417_at_news.belgium.eu.net>#1/1
Date: 1997/05/09
Message-ID: <337340dd.32303417_at_news.belgium.eu.net>#1/1
It cannot be difficult (this is what my boss said !)
I want to run a PL/SQL procudure on a unix machine (aix 3.2.5) with Oracle 7.1.6
I am starting the procedure in a unix shell. After the execution, I would like to see the (if any) Oracle error in this Unix shell (not in PL/SQL).
I need this error to report to another system.
With 'exit sql.sqlcode', I receive a number in Unix, but it isn't the Oracle error number !
In general I like to return any value from PL/SQL to UNIX
e.g. return value to Unix : 1651 -> ORA-001651 has occured
return value to Unix : field field1 must be filled in -> any number
Thanks in advance Received on Fri May 09 1997 - 00:00:00 CEST