SQL> create or replace procedure update_commission
2 (v_dept in number,v_pervent in number default 10) is
3 begin
4 update emp
5 set comm=sal*v_percent
6 where deptno=v_dept;
7 end
8 /
警告: 创建的过程带有编译错误。
SQL> show error
PROCEDURE UPDATE_COMMISSION 出现错误:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2/2 PLS-00103: 出现符号 ""在需要下列之一时：
( ; is with authid as cluster
compress order using compiled wrapped external deterministic
parallel_enable pipelined
符号 "" 被忽略。
4/2 PLS-00103: 出现符号 ""在需要下列之一时：
begin case declare exit for
goto if loop mod null pragma raise return select update while
with
<< close current delete fetch lock insert
LINE/COL ERROR
-------- -----------------------------------------------------------------
open rollback savepoint set sql execute commit forall merge
pipe
SQL> show errors procedure scott.update_commission
PROCEDURE SCOTT.UPDATE_COMMISSION 出现错误:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2/2 PLS-00103: 出现符号 ""在需要下列之一时：
( ; is with authid as cluster
compress order using compiled wrapped external deterministic
parallel_enable pipelined
符号 "" 被忽略。
4/2 PLS-00103: 出现符号 ""在需要下列之一时：
begin case declare exit for
goto if loop mod null pragma raise return select update while
with
<< close current delete fetch lock insert
LINE/COL ERROR
-------- -----------------------------------------------------------------
open rollback savepoint set sql execute commit forall merge
pipe
修改后的脚本：
SQL> create or replace procedure update_commission
2 (v_dept in number,v_pervent in number default 10) is
3 begin
4 update emp
5 set comm=sal*v_percent
6 where deptno=v_dept;
7 end;
8 /
警告: 创建的过程带有编译错误。
SQL> show error
PROCEDURE UPDATE_COMMISSION 出现错误:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/1 PL/SQL: SQL Statement ignored
5/14 PL/SQL: ORA-00904: "V_PERCENT": 无效的标识符
SQL> create or replace procedure update_commission
2 (v_dept in number,v_percent in number default 10) is
3 begin
4 update emp
5 set comm=sal*v_percent
6 where deptno=v_dept;
7 end;
8 /
过程已创建。
SQL> show error
没有错误。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/77164/viewspace-1008284/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- ORA-23515: 实体化视图和/或它们的索引存在于表空间中
- rac 缺失本地节点node1的信息
- ORA-01287 from a different database incarnation
- ORA-07445: exception encountered: [Address not mapped to object]
- ORA-06544: PL/SQL: internal error, arguments: [56319]
- ORA-01031 insufficient privileges
- ORA-00314: log 2 of thread 1, expected sequence# 53 doesn't match 2
- ORA-00600: internal error code, arguments: [4193],
- ORA-00313: open failed for members of log group
- ORA-01552: cannot use system rollback segment
