×

Loading...

yes, sql file and error message...

xiagangle(xiagangle)
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
(#838685@0)
Last Updated: 2002-11-5
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / 问一个oracle procedure的问题 -xiagangle(xiagangle); 2002-11-5 {213} (#838442@0)
    一个procedure写好了之后，如何执行呢？
    我在sqlplus下用exec执行，总是指出identifier 'procedure_name' must be declare?

    以前没有用过oracle, oracle procedure运行之前是否要compile以下？或者说是把它存到数据库里面？
    • do you use following statements to execute it: exec procedure_name? what is your procedure name? -rabbitbug(兔八哥); 2002-11-5 (#838461@0)
      • yes, sql file and error message... -xiagangle(xiagangle); 2002-11-5 {785} (#838685@0)
        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
        • 自己up以下 -xiagangle(xiagangle); 2002-11-5 (#838882@0)
        • I am thinking that might be caused by different username. -kew888(西竹); 2002-11-6 {495} (#839396@0)
          Look like you create a procedure and then try to execute it from SQL*Plus.
          The schema name of the procedure should be your login name when you create the procedure.
          If you still use the same login name to execute this procedure, there should be NO problem.
          But, there will be a problem if you use a different user to execute this procedure under the condition that you didn't grant execute priviledge to the new user.
          Just some thoughts, may need more detail to troubleshoot your problem.
        • Hi, you should use "@raise_salary.sql to run the sql file to create the procedure , after that you can use "select * from dba_source where name='procedure_name';" to check whether your procedure has -wander2001(猫行天下); 2002-11-6 {78} (#839521@0)
          been generated. If it's there,then you can "exec procedure_name' to exec it
          • thank you, this what I want. -xiagangle(xiagangle); 2002-11-6 (#839544@0)
            • before the "end raise_salary; ", I think you also need add a "end;" -ling7199(Michaell); 2002-11-15 (#856106@0)

More Topics

  • 这个怎么修？
  • Roadmap,最学的东西比较多，勉强搞清楚了辣椒番茄的育苗过程，勉强能编程esp32板，想也出一个STM32板，画板工程师搞好了，我学一下用Altium Designer，大模型的ＡＰＩ我试了一下，暂时还不太懂大模型的工作机会在哪里，虽然我知道方向在多模态，开始学习机器人ROS
  • Developer Roadmaps
  • 修好了
  • 这里高人多，娃有道考试题，有人指点一下吗？如何证明log(b/a) = (cos2a-cos2b) + (1/2)*(cos4a+cos4b)
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论