PLS-00201: identifier 'string' must be declared

PLS-00201: identifier 'string' must be declared
Cause: You tried 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 don't 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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:01

PLS-00201：必须声明标识符' string ',
.原因：您尝试引用未声明的变量，异常，过程或其他项目，或未授予权限的项目或仅通过角色授予权限的项目。,
.操作： 1）检查您的拼写和声明的引用名称。2）验证引用项目的声明是否正确放置在块结构中。3）如果引用的项目确实已被声明，但是您没有权限引用该项目，出于安全考虑，您将被通知只有该项目未被声明。4）如果引用的项目确实被声明，并且您认为您有权参考该项目，请检查权限; 如果仅通过角色授予权限，则这是预期的和记录的行为。存储的对象（包，过程，函数，触发器，视图）在对象所有者的安全域中运行，除了PUBLIC之外，不启用任何角色。再次，您将被通知该项目未被声明。,
.

aiaiDBA

13718043309

010-86462881

PLS-00201: identifier 'string' must be declared

1 个回答

相似问题