RE: :new and :old
Mercadante, Thomas F
:new and :old -- Mercadante, Thomas F 2005-06-16
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?
Sent: Thursday, June 16, 2005 8:48 AM
Subject: :new and :old
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
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
CURSOR cur1 IS
WHERE TRACKTABLENAME =3D 'COMPANY_MASTER'
FOR cur1_rec IN cur1
INSERT INTO AUDITLOG =20
Have fun online with music videos, cool games, IM and more. Check it