How to pass return value from a PLSQL procedure or function to a UNIX wrapper?

Home -> Community -> Usenet -> c.d.o.server -> How to pass return value from a PLSQL procedure or function to a UNIX wrapper?

From: Noah Wollowick <nwollowi_at_eecs.tufts.edu>
Date: Wed, 20 Oct 1999 12:06:55 -0400
Message-ID: <Pine.GSO.4.05.9910201203450.1746-100000@andante>

Hello all,

was wondering, what is the best/easiest way to take a return value from either a PL/SQL stored procedure or function that is set to 0 upon successful execution of the procedure or function, or is set to a value in the exception handler of the PL/SQL routine on some type of failure, and pass that value to a calling shell (i.e. Korn shell, SQL*Plus, or Perl wrapper?)

I need to do this so that the PL/SQL procedure or function can be called through a scheduler.

Any information or an example would be awesome!

Regards,
Noah Wollowick
noahclerk_at_aol.com Received on Wed Oct 20 1999 - 11:06:55 CDT