Re: convert delete to update

From: --- <---_at_noddy.land>
Date: Mon, 27 Oct 2003 11:57:05 GMT
Message-ID: <lK7nb.167210$bo1.28210@news-server.bigpond.net.au>

"Sunil" <sunil_franklin_at_hotmail.com> wrote in message news:817nb.5$nM4.153_at_news.oracle.com...
> Hi,
> Is it possible to convert a delete statement to an update by using a
> trigger.
> I am trying to do some thing like if a row from a table is deleted I
do
> not actually delete the row but need to only set a deleted flag.
>
> Any other ideas on how to achieve the above.
>
> Thanks,
> Sunil.
>
>
>

I don't know too much about what you are trying, but you are going to run into problems with a mutating trigger.
There are ways around it but it might be more trouble than it's worth. You could always insert the record into another table for "deleted entries"

Why don't you solve the issue programatically by not allowing the application to delete entries. Received on Mon Oct 27 2003 - 05:57:05 CST