PL/SQL termination status to Unix

From: steve roach <steve_at_stercon.demon.co.uk>
Date: 1995/10/01
Message-ID: <812560391.10539_at_stercon.demon.co.uk>#1/1


How would I report a PL/SQL script termination status to a calling Unix script? The Unix bit would look something like:

   sqlplus username/password ...
   echo $?

The PL/SQL, say, updates a table and needs to return a status code to Unix depending if the target row existed or not. I solved this one some years ago but with an older version of PL/SQL and within a VAX DCL script. I remember that it worked very well.

Assistance appreciated. Received on Sun Oct 01 1995 - 00:00:00 CET

Original text of this message