RE: :new and :old

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 16 Jun 2005 09:02:41 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF16E6F4@EXCNYSM0A1AJ.nysemail.nyenet>

Kean,

What exactly are you trying to do? =20
Is the trigger you are trying to create on the TRACKFLD table? If so, then the cursor would fail anyway - you cannot query the table that the trigger is acting on - you have no way of knowing what record is being changed in the cursor itself.

How about explaining what you need the trigger for?

Tom

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kean Jacinta Sent: Thursday, June 16, 2005 8:48 AM
To: oracle-l_at_freelists.org
Subject: :new and :old

Hi,

i have declare a cursor in my trigger called cur1. I am trying to refer :OLD.<dynamicfieldname> :NEW.<dynamicfieldname> from the cursor. I got an error=20

PLS-00049 bad-bind variable. I am not sure if oracle support this. If this way is not gonna work then what can you pls suggest other method to acheive the same result.=20

THank YOU
JKean

=20

Declare
CURSOR cur1 IS

    SELECT FIELDNAME=20

      FROM TRACKFLD=20
     WHERE TRACKTABLENAME =3D 'COMPANY_MASTER'

Begin
 FOR cur1_rec IN cur1

LOOP
    =20
INSERT INTO AUDITLOG =20
(FIELDNAME,AUDITBEFOREVALUE,AUDITAFTERVALUE)=20            =20
VALUES
(:FIELDNAME,:OLD.cur1_rec.FIELDNAME,:NEW.cur1_rec.FIELDNAME);

     =20
END LOOP;
 =20

        =09

__________________________________=20

Discover Yahoo!=20
Have fun online with music videos, cool games, IM and more. Check it out!=20
http://discover.yahoo.com/online.html

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 16 2005 - 09:07:55 CDT