raise_salary.sql

create procedure raise_salary (dno number, percentage number DEFAULT 0.5) is
cursor emp_cur(dept_no number) is
select SAL from EMP where DEPTNO=dept_no
for update of SAL;
empsal number(8);
begin
open emp_cur(dno)
loop
fetch emp_cur into empsal;
exit when emp_cur%NOTFOUND;
update EMP st SAL = empsal *((100+percentage)/100)
where current of emp_cur;
end loop;
close emp_cur;
commit;
end raise_salary;
/

SQL>exec raise_salary(7782)

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'RAISE_SALARY' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored