Re: create trigger

From: Zbigniew Sliwa <zibi_at_at_hotmail.com>
Date: 2000/08/02
Message-ID: <9wQh5.5968$ct3.139454@news.tpnet.pl>#1/1

Hi,

I think that you mean 04091 not 04901.
This is mutating table error.
This means that you can not query or modify the table in the trigger on this table.

For workaround look at:
http://osi.oracle.com/~tkyte/Mutate/index.html Good luck.

---

Regards,

Zbigniew Sliwa
Oracle Programmer

luio napisa³(a) w wiadomo¶ci:
<04886546.ab1a4a1f_at_usw-ex0104-028.remarq.com>...
>the trigger is valid not, but no matter I set it as before or
>after delete, it will report 04901 error.
>how can I void it?
>
>the only condition I used is like
>delete from table1 where table1.column1 = :old.cl1;
>
>
>????
>
>
>
>
>
>-----------------------------------------------------------
>
>Got questions? Get answers over the phone at Keen.com.
>Up to 100 minutes free!
>http://www.keen.com
>
Received on Wed Aug 02 2000 - 00:00:00 CDT