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 -> Re: using :new / :old values in a trigger (after inserting rows)

Re: using :new / :old values in a trigger (after inserting rows)

From: Cris Carampa <cris119_at_operamail.com>
Date: Tue, 08 Jul 2003 14:10:20 +0200
Message-ID: <beecbc$ptc$1@panco.nettuno.it>


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

Original text of this message

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