identifier must be declared

[frustratedghie]

hi experts! i have a code here but it not working. i am getting an error of "identifier SCOTT.EMP_INFO must be declared", 'SQl statement ignored". but SCOTT.EMP_INFO is a table.

here's the code:

declare
mess number;
v_empid number(25);
v_lname varchar2(100);
v_end date;



begin

if :emp_info1.emp_id is not null then

select emp_id, lname ||','||' '||fname||' '||substr(mname,1,1)||'.'
into v_empid,v_lname
from scott.emp_info

where emp_id= :emp_info.emp_id;

if v_empid is not null then

insert into scott.payroll(emp_id,
lname,
end_payroll)

VALUES (v_empid,
v_lname,
sysdate);

:system.message_level := 25;

go_block('payroll');


set_block_property('payroll',default_where, 'emp_id = :emp_info1.emp_id');
execute_query;



end if;
end if;

end;

[vijaydiwakar]

Do u have emp_info1 ?
if not then erase 1 from that and try to run it