Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> URGENT - Trigger error

URGENT - Trigger error

From: David Maya <maya_at_grn.es>
Date: Tue, 26 Oct 1999 22:40:22 +0200
Message-ID: <7v53fi$jan$1@diana.bcn.ttd.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US