How to show DB Trig Message in Forms3.0

From: Marty Adolf <madolf_at_teleport.com>
Date: 1996/09/11
Message-ID: <Pine.SUN.3.92.960911165428.26355B-100000_at_kelly.teleport.com>#1/1


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

Original text of this message