Dear Sathiya
The mutating tables error is caused by the row level trigger. This does
not happen in a statement level trigger. This is the key to the
solution. You use a row level trigger to store references to the data
you want to change and then a statement level trigger to actually update
the records.


Hope that helps
All the best

Ajay

-----Original Message-----
From: Sathiya
[mailto:oracledba-ezmlmshield-x93849648.[Email address protected]
Sent: Wednesday, August 18, 2004 10:27 AM
To: LazyDBA Discussion
Subject: Error in Insert -- Table mutating

Dear Gurus,

I am getting below error while trying to insert into the table. Can
anyone help

ORA-04091: table UGBL.GGBL_EIAS_LOC is mutating, trigger/function may
INSERT INTO GGBL_EIAS_LOC
(EIL_CODE,EIL_ACTIVE,EIL_DESC,EIL_START_DATE)....

Regards
Sathiya


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page