declare
a number;
begin
if :qy.div_name is not null then
if :qy.emp_name is not null then
update salary_processing
set p_date :='qy.p_date

where emp_code :='qy.emp_code
and div_code :='qy.div_code
and yearmonth :='qy.yearmonth;
forms_ddl('commit');
:buttons.msg :='R E C O R D U P D A T E D S U C C E S S F U L L Y ! ! !';

else
:buttons.msg:='S E L E C T E M P L O Y E E N A M E';
go_item('qy.emp_name');
end if;
end;




message error103 line7 column14
encountered the symbol "=" when expecting one of the following
.@=

declare
a number;
begin
if :qy.div_name is not null then
if :qy.emp_name is not null then
update salary_processing
set p_date ='qy.p_date

where emp_code ='qy.emp_code
and div_code ='qy.div_code
and yearmonth ='qy.yearmonth;
forms_ddl('commit');
:buttons.msg :='R E C O R D U P D A T E D S U C C E S S F U L L Y ! ! !';

else
:buttons.msg:='S E L E C T E M P L O Y E E N A M E';
go_item('qy.emp_name');
end if;
end;