How to show DB Trig Message in Forms3.0

Any help to this is welcome.

I have created a database trigger to prohibit a particular update circumstance. I want to display a meaningful message in Forms 3.0, but the only way I have discovered to get a message is to capture the error code in the On-Update trigger and writing a message in the Exception clause. Which would be fine except I have to write the update statement in the trigger as well and this has seriously degraded performance.

Is this the only way to get a meaningful message to appear in Forms 3.0 in response to user-defined database trigger failure? Am I doing something wrong?

Thanks! Received on Wed Sep 11 1996 - 00:00:00 CEST