Re: key-commit
Date: Tue, 8 Oct 2002 19:51:47 +0200
Message-ID: <anv6dp$er7$1_at_reader12.wxs.nl>
Use PRE-INSERT and PRE-UPDATE on form or block-level.
Suppose that with row-level trigger you mean database trigger.
If there is a raise_application_error in your trigger, include the ID of your message or the
message as second parameter.
For example raise_application_error(-20001,'APP-00001');
You can catch this error with DBMS_ERROR_CODE (-200001) and DBMS_ERROR_TEXT (APP-00001) in your
ON-ERROR trigger and call a generic procedure for message handling
"Daud" <daud11_at_hotmail.com> wrote in message news:f0bf3cc3.0210071424.60d784ed_at_posting.google.com...
> Q1. From block-level trigger of key-commit, how can I tell if I am
> trying to commit a new record or an updated record?
>
> Q2. If a row-level trigger raises an exception how can I find this out
> and handle this exception in my form?
>
> thanks
> Daud
Received on Tue Oct 08 2002 - 19:51:47 CEST