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 -> ORA-04091 workaround needed

ORA-04091 workaround needed

From: Peter Bittner <bittner_at_teamworks.eu.com>
Date: Tue, 21 Jun 2005 06:57:19 +0200
Message-ID: <42b79e19$0$11993$79720d31@newsreader.inode.at>


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

Original text of this message

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