Re: How to know in a unix script if oracle procedure executed or failed?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 11 Dec 2003 21:31:16 +0100
Message-ID: <9skhtv4ntqgpl8n0p40psilg2pod203dg5_at_4ax.com>


On Thu, 11 Dec 2003 19:28:33 +0100, Thorsten Hs <eifel-power_at_t-online.de> wrote:

>Hello,
>
>you can use some other solution:
>
>#!/usr/bin/ksh
>>> sqlplus user/password_at_name <<EOC>/tmp/log/log_file_unix_shell.log
>>> set time on
>>> set echo on
>>> select sysdate from dual
>>> ;
>>> spool procedureName.log
>>> exec procedureName
>>> spool off
>>> exit
>>> EOC
>
>you find the output of your user(SQL)-session in the
>/tmp/log/log_file_unix_shell.log-File.
>
>best regards
>thorsten hs
>
He wants to know *in the script* whether his procedure succeeded., not by looking at log files. Your solution doesn't work, so why contradict me with a non-working solution where my solution does work?

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Dec 11 2003 - 21:31:16 CET

Original text of this message