PLS-00302 error

From: Gennady <gennadyb_at_halcosoftware.com>
Date: 2000/05/04
Message-ID: <3911cb41$0$6553@fountain.mindlink.net>#1/1

Hello,
In my PL/SQL code I have a variable of ROWTYPE and I try to access  the variable component using another variable, but I got an errorr: "PLS-00302: component 'CNROW' must be declared". The code is:
declare
cursor c1 is select * from old;
old_row old%ROWTYPE;
cursor c2 is select * from new;
new_row new%ROWTYPE;
cursor c3 is select column_name from user_tab_columns where table_name = 'OLD';
cnrow user_tab_columns.column_name%TYPE; begin
dbms_output.enable;

open c1;
open c2;
open c3;

loop
  fetch c1 into old_row;
  fetch c2 into new_row;
exit when (c1%notfound or c2%notfound);
end loop;
loop
  fetch c3 into cnrow;
  If (old_row.cnrow = new_row.cnrow) then -- error in this line!

     dbms_output.put_line('SAME VALUE');   else

     dbms_output.put_line('DIFFERENT VALUE');   end if;
exit when c3%notfound;
end loop;
end;

How can I fix the problem??
Thanks,
Gennady Received on Thu May 04 2000 - 00:00:00 CDT