Re: Check error

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Tue, 2 Oct 2001 11:49:24 -0400
Message-ID: <9pcnlj$hdref$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

"Gloria Zhao" <gloriaz_ca_at_yahoo.com> wrote in message news:fcb331b6.0110020622.711756a2_at_posting.google.com...
> Hi there,
>
> I am wondering if there is a way to check if a PL/SQL program
> ran successfully in unix shell script. I used to check log file
> which has sqlerrm and sqlcode. But I am just wondering if I could
> do it by
> checking the return value of a PL/SQL program.
>
> Thanks a lot.
>
> Gloria

In your sql script immediately before the pl/sql add the following line...

whenever sqlerror exit failure

In your shell script, if the return code is non-zero, there was an error.
- --
Chuck Hamilton
chuck_hamilton_at_yahoo.com

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO7niAWm5A4kkb4ZsEQJqTgCdE4/QAGZtAh3NXBxR5nM+tndHHWQAn0BI wnIEGWWgRIqwk9+5M5Jas5lB
=eoV8
-----END PGP SIGNATURE----- Received on Tue Oct 02 2001 - 10:49:24 CDT