Status error in a Shell script UNIX

Hi,
I want to capture the status error of my procedure in a Shell script UNIX. I don't know how to put the status error in my procedure. Can somebody help me or send me any suggestion ? For example :

my Shell script:

sqlplus -s user/password << FIN

    execute proc_test;
FIN
=>proc_test must generate an error and I want to test this error ( if $error
= ... then )

Thank's for your help. Received on Wed Apr 01 1998 - 00:00:00 CST