PLS-00201 identifier 'string' must be declared
Cause: An attempt was made to reference either an undeclared variable, exception, procedure, or other item, or an item to which no privilege was granted or an item to which privilege was granted only through a role. Action: 1. Check your spelling and declaration of the referenced name. 2. Verify that the declaration for the referenced item is placed correctly in the block structure. 3. If the referenced item is indeed declared but you do not have privileges to refer to that item, for security reasons, you will be notified only that the item is not declared. 4. If the referenced item is indeed declared and you believe that you have privileges to refer to that item, check the privileges; if the privileges were granted only via a role, then this is expected and documented behavior. Stored objects (packages, procedures, functions, triggers, views) run in the security domain of the object owner with no roles enabled except PUBLIC. Again, you will be notified only that the item was not declared.
Cause: An attempt was made to reference either an undeclared variable, exception, procedure, or other item, or an item to which no privilege was granted or an item to which privilege was granted only through a role. Action: 1. Check your spelling and declaration of the referenced name. 2. Verify that the declaration for the referenced item is placed correctly in the block structure. 3. If the referenced item is indeed declared but you do not have privileges to refer to that item, for security reasons, you will be notified only that the item is not declared. 4. If the referenced item is indeed declared and you believe that you have privileges to refer to that item, check the privileges; if the privileges were granted only via a role, then this is expected and documented behavior. Stored objects (packages, procedures, functions, triggers, views) run in the security domain of the object owner with no roles enabled except PUBLIC. Again, you will be notified only that the item was not declared.
解决方案 »
- 请问这个SQL为什么会错?
- ORA-01031: 权限不足
- oracle 查询问题 急
- 如何不用建时间字段的索引就能快速进行特定时间段内数据的查询呢?请进来看看。
- 如何把在用PLSQL 实现下面的功能阿?
- 用sqlplus怎样把数据导到excel表格中去?
- 日期类型在windows中和在Linux中有区别吗
- 大家好,请教一个sql语句问题!!着急,在线等啊
- 创建库的过程中出错(急),请专家指点
- 请问怎样在ORALCE8I中导入SQL SERVER2000中的一个表!
- Oracle9i中,要判断一个表是否存在,如果存在,就删除此表重新建立,没有就不删除重建,SQL该如何写?
- ORACLE安装的字符集问题
如果是该如何授权,
但是如果在DP2000使用该语句就没有这个问题
但是单独作为一个存储过程,就会报错,
如何在存储过程中调用文档输出功能(将记录输出到EXCEL文档中)
text_io 是dp2000的一个包
在数据库里应该使用utl_file