aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

PLS-00327: "string" is not in SQL scope here

PLS-00327: "string" is not in SQL scope here
Cause: In a SQL statement, a reference was made to an out-of-scope database object. The referenced object might be misspelled, or the reference might be mixed, as in the following example: CURSOR c1 IS SELECT dept.dname FROM emp;
Action: Check the spelling of all database objects in the SQL statement, and make sure all references are to objects within the current scope.

请先 登录 后评论

1 个回答

小智
PLS-00327:“ string ”在这里不在SQL范围内,
.原因:在SQL语句中,引用了超出范围的数据库对象。引用的对象可能拼写错误,或者引用可能会混合,如以下示例所示:CURSOR c1 IS SELECT dept.dname FROM emp;,
.操作:检查SQL语句中所有数据库对象的拼写,并确保所有引用都是当前范围内的对象。,
.
请先 登录 后评论