I have a problem with ORacle's trigger. I'm trying to use
the function :
raise_application_error
within a trigger in order to stop the update of a table and
issue a customised error.
The function does in fact stop the execution of the update , and
isssue the right customised message, but when the application
see that the update is stopped, it returns (or ORacle returns) two other
messages saying that there was an execution error in the trigger.
How can yu avoid the displaying of the two last message? Or, how do
, or can you stop the execution of an update from within a trigger (
BEFORE or AFTER one?
Thanks!
MArtin Miron
e-mail: minto_at_info.polymtl.ca
Martin.Miron_at_dmr.ca
Received on Sun Apr 23 1995 - 00:00:00 CEST