Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-04091 workaround needed
Hi!
I have a simple problem which needs a probably not so simple solution:
I am customizing an application that accesses a database (in this special case Oracle 9i), and I need to react after this application adds data to a specific table.
The problem now is: When I write an INSERT trigger (AFTER INSERT ON MYTABLE FOR EACH ROW ...) to perform an UPDATE on MYTABLE I get an ORA-04091 error saying "Table MYTABLE is being modified, trigger might not see it".
I have searched the web for this problem and it seems to be rather common. But still, I think this is a more or less trivial problem - though the solution might not be. :-(
Anybody know a proper solution to this?
Cheers, Peter Received on Mon Jun 20 2005 - 23:57:19 CDT