Re: PRE-COMMIT and "RAISE Form_Trigger_Faiure"

From: Richard Senior <richard_at_r-senior.demon.co.uk>
Date: 11 Aug 2001 07:27:07 GMT
Message-ID: <9l2mob$d7q$1_at_gate.local>


In article <1cBc7.2243$an2.39948_at_nnrp1.ptd.net>,

        "John" <john_millhouse_at_yahoo.com> writes:

> I have stripped down the pre-commit trigger of the non working form to one
> line...
> RAISE Form_Trigger_failure;
>
> I have a button which the PL/SQL block looks like this...
> COMMIT_FORM;
> BELL;
>
> I would expect to never get to the BELL statement when pressing the button,
> but I do.
>
> Is there some item, block, or form property I am overlooking here?

Is there another PRE-COMMIT trigger at another level that is set to override your PRE-COMMIT trigger?

-- 
Regards,

Richard Senior
Mill Dam Consulting Ltd, London
Oracle Consulting & Training
Received on Sat Aug 11 2001 - 09:27:07 CEST

Original text of this message