Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Delete trigger
"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
![]() |
![]() |