×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

@Florida

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

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论