could somebody check this code for me?
declare
h00019852_salary employees.salary%type;
begin
select salary,last_name into h00019852_salary
from employees
where last_name=&h00019852_gv_empname;
update employees
set salary = salary +500
where if salary < 3000 then
dbms_output.put_line(h00019852_gv_empname||' 's salary updated');
else
dbms_output.put_line(h00019852_gv_empname||' earns salary of '|| h00019852_salary);
end if;
end;
i get this error
old 8: where last_name=&h00019852_gv_empname;
new 8: where last_name=Pataballa;
ERROR:
ORA-01756: quoted string not properly terminated