Re: Doing Validation before Commit

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 02 Dec 2004 06:35:59 -0800
Message-ID: <1101998063.564651_at_yasure>


elie.constantine_at_gmail.com wrote:
> Ok... Sorry for any inconveniences.
>
> The FORM_TRIGGER_FAILURE call will be in the procedure.
> But from which trigger I should make a call to this procedure. In the
> POST-FORM, KEY-COMMIT, ON-COMMIT.....????? This procedure can also be
> written to post the details data block, do the check then in case some
> rules were not met raise the error and prohibit the data in both master
> and detail blocks from been committed.
>
>
> Regards,
> Elie,

No ... it is a procedure not a trigger. Write:

BEGIN
   .. your code here
EXCEPTION
   WHEN <some_condition> THEN
     .. whatever you wish
END;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Dec 02 2004 - 15:35:59 CET

Original text of this message