Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: using :new / :old values in a trigger (after inserting rows)
Jon wrote:
> When running, it returns the following error: ORA-04091.
ORA-04091 has nothing to do with :new and :old values. This error means that in your trigger code you are performing a SELECT statement or a DML statement against the table upon which the trigger is based. This is not allowed.
-- Cris Carampa (spamto:cris119_at_operamail.com) Berlusconi's corollary to Godwin's Law: "As a parliament discussion grows longer, the probability of a comparison involving Nazis or Hitler approaches one."Received on Tue Jul 08 2003 - 07:10:20 CDT