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

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 - 15:18:38 CST