aiaiDBA

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

13718043309

010-86462881

PLS-00493: invalid reference to a server-side object or function in a local context

PLS-00493: invalid reference to a server-side object or function in a local context
Cause: A reference to a server-side object (e.g. a table column) or function (a group function such as SUM, AVG, MIN, MAX, ... ) was found in a context where only PL/SQL objects may be present (such as within the parameter list of a local function or as the index of a (local) PL/SQL table.)
Action: Rewrite the offending statement; or (if a local function call is the problem context), make the function non-local (either packaged or top- level.)

请先 登录 后评论

1 个回答

小智
PLS-00493:对本地上下文中服务器端对象或函数的无效引用,
.原因:在只有PL / SQL对象可能存在的上下文中找到对服务器端对象(例如表列)或函数(诸如SUM,AVG,MIN,MAX,...等组功能)的引用(例如在本地函数的参数列表内或作为(本地)PL / SQL表的索引)。,
.行动:重写违规陈述; 或者(如果本地函数调用是问题上下文),使函数非本地(打包或顶层)。,
.
请先 登录 后评论