Re: Before update trigger question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 08 Feb 2000 07:12:31 GMT
Message-ID: <389fc1ac.4424057@news.demon.nl>

On Mon, 07 Feb 2000 20:20:22 GMT, Bob <meyer_b_at_my-deja.com> wrote:

>When using a statement level, Before Update trigger, is it possible to
>have the trigger prevent the update from happening based on a certain
>condition? If so, how do I go about this?
>
>Thanks much,
>
>--
>Bob M.
>
>Step outside. The graphics are AMAZING!
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

IF error_condition holds true then
raise_application_error(<any number <= -20000,'any text') end if;

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Feb 08 2000 - 01:12:31 CST