Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> URGENT - Trigger error
Hello :
I'm using Oracle 8i, and I've the next problem:
I've two tables TABLE1 TABLE2
TABLE1 have one PK, that is the FK of TABLE2
I've an AFTER UPDATE TRIGGER in TABLE1, that inserts in TABLE2 the actual updated record from TABLE1. OK by now.
BUT when I really Update a record in TABLE1, Oracle gives me the next error :
SQL ERROR, TABLE1 IS MUTANT What can I do ??
Thank you in advance
David Received on Tue Oct 26 1999 - 15:40:22 CDT