How to know in a unix script if oracle procedure executed or failed?
From: vishal <c_vishal_at_hotmail.com>
Date: 10 Dec 2003 13:18:38 -0800
Message-ID: <24327b26.0312101318.5b1c4f4c_at_posting.google.com>
Hi,
Date: 10 Dec 2003 13:18:38 -0800
Message-ID: <24327b26.0312101318.5b1c4f4c_at_posting.google.com>
Hi,
I am writing my first script to execute a Oracle procedure through a
unix script. Could you tell me how do I do error handling here? How do
I know in my script if the procedure executed successfully or failed?
Thanks
#!/usr/bin/ksh
sqlplus user/password_at_name <<EOC
set time on
set echo on
select sysdate from dual
;
spool procedureName.log
exec procedureName
spool off
exit
EOC
Received on Wed Dec 10 2003 - 22:18:38 CET