Re: Delete trigger

From: Yong <yhuang_at_slb.com>
Date: 2000/07/12
Message-ID: <8kib2e$mlc$1@news.sinet.slb.com>#1/1

Maybe I misunderstand. But could you simply

(1) put null;

(2) or put raise_application_error(-20002,'');

in the trigger body?

Yong Huang

Mark D Powell <mark.powellNOmaSPAM_at_eds.com.invalid> wrote in message news:0236ff0d.199f06d4_at_usw-ex0102-015.remarq.com...
> "Yann Cauchard" <yann.cauchard_at_spcconsultants.com> wrote:
> >Hello,
> >
> >I have to avoid deleting lines in a table using a trigger.
> >I started to write a before delete trigger, which returns some
error
> >messages.
> >But i'd like to return no messages, or a custom message.
> >Can someone help ?
> >
> >Thanks in advance.
> >
> >Yann CAUCHARD
> >
> The only way I can think of to stop the delete would be to
> raise_application_error(-20002,'Deletes are not allowed'). This
> will allow you to send a message, but I do not know any way to
> send no message, but depending on the front-end applicaion you
> should be able to control what the user sees.
>
>
>
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Wed Jul 12 2000 - 00:00:00 CDT