Hi,

I have a plsql procedure, which raises an exeption on some condition or simply exits. Now if my procedure raises exeption, then i want to use this error to perform some operation in unix shell script.

I want something like this

#unix script starts
#connect to sql
#call a procedure
#exit from sql
#if (procedure raises an error) then
# ACTION else
# exit....

I think my question is clear to you all.