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
I think my question is clear to you all.