yes, sql file and error message...

xiagangle (xiagangle)

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);
open emp_cur(dno)
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;
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
2002-11-5 -04:00
Share Online by QR Code

Back To Topic: 问一个oracle procedure的问题

Back To Forum: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论