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

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

From: Jon <aaa_at_bbb.ccc>
Date: Tue, 8 Jul 2003 12:18:53 +0200
Message-ID: <bee5n7$m3j$1@unbe.sarenet.es>


I am trying run an AFTER INSERT trigger that reads both :new and :old values corresponding to some of the columns of the record I am trying to insert. When
running, it returns the following error: ORA-04091. Following Oracle manuals, I
understood that I could read these values altough I cannot write to them as it
is an AFTER INSERT trigger. Thanks Received on Tue Jul 08 2003 - 05:18:53 CDT

Original text of this message

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