Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Before update trigger question

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US