Error handling

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