Exception from Trigger through procedure

Here is the situation:
I have a program (Powerbuilder 6) which calls a procedure within Oracle. The procedure changes a value in a table which has a trigger which raises an exception when a certian value is wrong. When updating the table through SQL*Plus no problem whe exception is raised and the appropriate message is returned. However when the procedure updataes the table the exception (from the trigger) is lost because of the scope of the exception in the trigger.

Does anyone know any way to get the trigger exception, passed back through the procedure and into the program where it can be displayed for the user.

Any thoughts appreciated.

Thanks JB
jeb_at_fayettevillenc.com Received on Mon Nov 23 1998 - 00:00:00 CST