On Thu, 11 Dec 2003 19:28:33 +0100, Thorsten Häs
<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 häs
>
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 - 14:31:16 CST
