PLS-00231 function name may not be used in SQL

最新推荐文章于 2021-04-12 02:44:51 发布

观想

最新推荐文章于 2021-04-12 02:44:51 发布

阅读量1.5k

点赞数 2

分类专栏： Oracle故障处理文章标签： PLS-00231 局部函数

本文链接：https://blog.csdn.net/yoursly/article/details/79623903

版权

Oracle故障处理专栏收录该内容

6 篇文章 0 订阅

订阅专栏

在存储过程或函数的声明部分，定义一个局部函数，结果在select中使用时报PLS-00231错误。

PLS-00231: function ‘string’ may not be used in SQL
Cause: A proscribed function was used in a SQL statement. Certain functions such as SQLCODE and SQLERRM can be used only in procedural statements.
Action: Remove the function call from the SQL statement. Or, replace the function call with a local variable. For example, the following statement is illegal: INSERT INTO errors VALUES (SQLCODE, SQLERRM); However, you can assign the values of SQLCODE and SQLERRM to local variables, then use the variables in the SQL statement, as follows: err_num := SQLCODE; err_msg := SQLERRM; INSERT INTO errors VALUES (err_num, err_msg);

根据不同的场景选择相应的处理办法：
1.改成赋值操作，aa:=f()
2.把主程序改成包，将函数定义在包里