Forms Question - Handling Errors

Hi all, I have a trigger on a table that uses the RAISE_APPLICATION_ERROR function to put out a custom message out to the user. This works fine when the exception gets tripped in SQLPLUS, but when the exception is tripped from inside my Forms application, I just get the standard Oracle error, in this case "Unable to insert record".

How do I show the custom error I implemented in my table trigger. I have tried the DBMS_ERROR_TEXT built in, but this just returns me the standard Oracle error.

Any help would be very appreciated,

--
Mark Cudmore
email: mcudmore_at_kamloops.env.gov.bc.ca