PLS-S-00201, identifier 'CALLDEMO.GET_EMPLOYEES' must be declared 预编译错误原因及解决办法
来源:互联网 发布:在线程序员计算器 编辑:程序博客网 时间:2024/05/16 17:47
$ proc sample9.pc SQLCHECK=SEMANTICS
Pro*C/C++: Release 11.2.0.1.0 - Production on Tue Jan 8 15:18:40 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
System default option values taken from: /usr/local/oracle/product/11.2.0/dbhome_1/precomp/admin/pcscfg.cfg
Error at line 116, column 19 in file sample9.pc
BEGIN calldemo.get_employees
..................1
PLS-S-00201, identifier 'CALLDEMO.GET_EMPLOYEES' must be declared
Error at line 116, column 19 in file sample9.pc
BEGIN calldemo.get_employees
..................1
PLS-S-00000, Statement ignored
Semantic error at line 116, column 13, file sample9.pc:
BEGIN calldemo.get_employees
............1
PCC-S-02346, PL/SQL found semantic errors
Pro*C/C++: Release 11.2.0.1.0 - Production on Tue Jan 8 15:18:40 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
System default option values taken from: /usr/local/oracle/product/11.2.0/dbhome_1/precomp/admin/pcscfg.cfg
Error at line 116, column 19 in file sample9.pc
BEGIN calldemo.get_employees
..................1
PLS-S-00201, identifier 'CALLDEMO.GET_EMPLOYEES' must be declared
Error at line 116, column 19 in file sample9.pc
BEGIN calldemo.get_employees
..................1
PLS-S-00000, Statement ignored
Semantic error at line 116, column 13, file sample9.pc:
BEGIN calldemo.get_employees
............1
PCC-S-02346, PL/SQL found semantic errors
$
错误原因:需要指定 “CALLDEMO.GET_EMPLOYEES” 的所属用户。
如上面的例子:
$ proc sample9.pc SQLCHECK=SEMANTICS userid=scott/tiger
Pro*C/C++: Release 11.2.0.1.0 - Production on Tue Jan 8 15:25:20 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
System default option values taken from: /usr/local/oracle/product/11.2.0/dbhome_1/precomp/admin/pcscfg.cfg
$
编译通过!
- PLS-S-00201, identifier 'CALLDEMO.GET_EMPLOYEES' must be declared 预编译错误原因及解决办法
- oracle adg PLS-00201: identifier 'DBMS_RCVCAT.GETDBID' must be declared
- Oracle 11gR2 RMAN Duplicate 触发PLS-00201: identifier 'DBMS_RCVCAT.GETDBID' must be declared 错误
- PLS-00201: identifier 'SYS.DBMS_JOB' must be declared 错误处理办法
- ORACLE 11G 触发器调试记录Error: PLS-00201: identifier'SYS.DBMS_SYSTEM' must be declared
- EXP-00056:ORA-06550:PLS-00201: identifier ‘SYS.DBMS_EXPORT_EXTENSION’ must be declared
- oracle 11.2.0.3 expdp 时报错,PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
- identifier 'SYS.DBMS_LOCK' must be declared错误处理方法
- PLS-00302: component 'SET_NO_OUTLINES' must be declared
- 数据库Server版本造成的导出错误PLS-00302: component 'SET_NO_OUTLINES' must be declared
- identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
- 也遭遇 PLS-00302: component 'SET_NO_OUTLINES' must be declared
- imp PLS-00302: component 'SET_NO_OUTLINES' must be declared【转载】
- Oracle 11gR2 RMAN Duplicate 触发PLS00201: identifier 'DBMS_RCVCAT.GETDBID' must be declared 错误
- 错误:Element type "select" must be declared.
- imp PLS-00302: component 'SET_NO_OUTLINES' must be declared 问题的处理
- 存储过程里的序列报错Error: PLS-00302: component 'SEQUENCE_NAME' must be declared
- Attribute "column" must be declared for element type "property"解决办法
- 踏实地走出追求智慧的求学路
- linux下部分头文件的作用
- 操作系统大型实验进展(1)-----c++ 初始化文件
- 你知道android里的“点九”吗?
- proxy
- PLS-S-00201, identifier 'CALLDEMO.GET_EMPLOYEES' must be declared 预编译错误原因及解决办法
- VC++实现文件的自我删除
- 队列的简单实现
- Oracle 11gR2 Patchset 不同文件作用 说明
- 外部类类名.this.varName 访问外部类实例属性 ; 通过 this.varName 访问外内部类实例的属性
- [UNIX环境高级编程]apue.h头文件的配置
- mysql将字符转换成数字
- 一个VC6的工程转换为VS2008的工程后,编译找不到而且不能升级vc90.pdb文件的问题解决方法 2010-9-28 14:00
- linux语言支持(关于在terminal中显示乱码的问题)