Thread: Pl/sql
View Single Post
Old May 12th, 2008, 1:22 AM   #4
A.K.Al Shamsi
Programmer
 
A.K.Al Shamsi's Avatar
 
Join Date: Mar 2008
Posts: 35
Rep Power: 0 A.K.Al Shamsi is on a distinguished road
Re: Pl/sql

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
A.K.Al Shamsi is offline   Reply With Quote