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>
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