Re: SQL*PLUS and shell scripts

Prashant Gaba wrote:
>
> Hi All,
>
> I am trying to productionise some of the queries that we run.
> My question is:
> How can I return the sql error code to a Unix shell script?
> I tried putting "WHENEVER SQLERROR EXIT SQLCODE" and although sqlplus
> exits with an error it does not return the correct code to the shell
> script which always displays 1.
>
> I also tried hardcoding 942 in place of sqlcode and when i displayed the
> error code in the shell script it displays 174.
> I know this is possible as I have done this DCL on VMS but I am missing
> something here.
> Can some one help????
>
> Thanks
> --
> Prashant Gaba
> Consultant
> e-mail: pgaba_at_usccmail.bms.com

Hi,

  If this is the scenario, then spool the output of the sql statements you run to an temporary file and use the grep command for ERROR or ORAin  that temporary file and display the appropriate error.

Thanks & Regards

K.Rajesh
Oracle DBA Received on Fri Mar 14 1997 - 00:00:00 CST