I think it depends on the severity of the error, some of the errors abort and rollback the transaction and it will be difficult to trap in SQL. Can't you trap/look at the error returned to your app, if its not your known error returned then you will have to do the job yourself.