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

Original text of this message