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

From: gojo <kckcabc_at_email.com>
Date: Mon, 23 Oct 2000 17:50:42 -0400
Message-ID: <39F4B2B2.A70561EB@email.com>

I tried the method of variable_name = `sqlplus tiger/scott`, and it is returning me the result i wanted. Do I have to ensure the ORACLE (i.e. Serverout, FeedBack ) settings are setup correctly? If so, what are they?

Thanks,
Ken.

sybrandb_at_my-deja.com wrote:

> In article <8t15o4$n45$1_at_nnrp1.deja.com>,
> edwardmi1_at_my-deja.com wrote:
> > 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.
> >

>

> Contrary to what you say, the variable in the exit clause will end up
> in the rc variable, thus *outside* sqlplus. I am quite positive about
> this and just to be sure I have checked this.
> Also by running sqlplus in silent mode you can make sure
> your standard output ends up in a variable by using
> variable=`sqlplus .... @script`
> As this is Unix this is quite obvious.
> You please don't spread information which is obviously incorrect, sorry
> to say so.

>

> Regards,

>

> --
> Sybrand Bakker, Oracle DBA

>

> All standard disclaimers apply
> ------------------------------------------------------------------------

>

> Sent via Deja.com http://www.deja.com/
> Before you buy.
  Received on Mon Oct 23 2000 - 16:50:42 CDT