ScottMattes
Member³
Why can't I see the value of a field in a record defined for my cursor? If I had code like below defined in a procedure and I was trying to see the value of emp.empno in the IF statement I can't set the value (because the right click menu does not show the option) or view the collection (the menu item is shown, but does nothing).
Code:
cursor c_emp is
select *
from emp;
emp_rcd c_emp%rowtype;
being
open c_emp;
fetch c_emp into emp_rcd;
if emp.empno = 1
then
do this;
else
do something else;
end if;
close emp;
end;
