Hi,
I am a oracle PL/SQL newbie.Can someone please help me solve the below
problem?
Consider a table called mytable with one column called mycol .I have
written a on-update trigger.
CREATE OR REPLACE TRIGGER "testtrigger" BEFORE
UPDATE ON mytable FOR EACH ROW
DECLARE
Test VARCHAR(1000);
BEGIN
TEST:='mycol';
IF :OLD.TEST <> :NEW.TEST THEN
DBMS_OUTPUT.PUT_LINE ("Hi");
END IF
i get the error bad bind variable.This is obviously because the
compiler is thinking that test is a column and not a variable.How
should I make the compiler aware that Test is a variable and the
compiler must resolver it to mycol? I know i can replace the variable
with mycol but that not what I want to do.
Thanks in advance!
Priya
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
