Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Delete trigger
Hi Yann
Have you considered writing a package that is able to remember the data to be deleted (via a before trigger) and then can restore that data afterwards (via an after trigger).
This would allow you to return without an error code and without the data deleted.
eric
On Wed, 12 Jul 2000 15:02:52 +0200, "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
>
>
Received on Sun Jul 16 2000 - 00:00:00 CDT