Re: How to return an value from Oracle to Unix in a shell scrtip.

In article <8t0v00$ilf$1_at_nnrp1.deja.com>,   sybrandb_at_my-deja.com wrote:
> In article <39EDF96B.3A805BF1_at_email.com>,
> gojo <kckcabc_at_email.com> wrote:
> > Hi there,
> >
> > I've a shell script that runs some Oracle procedures, what I would
 like
> > to know is if the Oralce procedure was successful or had any error.
> > Basically a flag that tells me everything is OKed, so I can do
 something
> > else in the subsequent shell codes.
> >
> > Does anyone what are the methods to achieve that ?
> >
> > Thanks,
> > Ken.
> >
> >
> include
> whenever sqlerror exit return_value|variable_name|:bind_variable
> in your sqlplus script and the value you use will be passed as return
> code, and of course you can query that by $?
>
> Hth,
> --
> Sybrand Bakker, Oracle DBA

I've understood Ken's question in the following way: How can we return to the Unix shell script the result of the termination of the sqlplus script that has been called from this shell script (like batch mode)? A bind variable let us get the result of the termination of an Oracle procedure in the SQL*Plus session/script, but not outside it - I mean - not in the shell script. A bind variable of SQL*Plus is not same as a variable of the Unix shell script.

Really, I've never been faced with such sort of problem before - may be - try to spool result of sqlscript and then read this file in the shell, or parse the stdout of the sqlplus command.

Edward,
Oracle Developer,
edwardmi_at_iname.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 23 2000 - 06:00:21 CDT