ORA-06571: Function string does not guarantee not to update database

ORA-06571: Function string does not guarantee not to update database
Cause: There are two possible causes for this message:
* A SQL statement references a packaged, PL/SQL function that does not contain a pragma that prevents the database from being updated.

* A SQL statement references a stand-alone, PL/SQL function that contains an instruction to update the database.

Action: If the referenced function is a packaged, PL/SQL function: Recreate the PL/SQL function with the required pragma; be certain to include the 'Write No Database State' (WNDS) argument in the argument list of the pragma. If the referenced function is a stand-alone, PL/SQL function: Do not use the function.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:38

ORA-06571：函数字符串不保证不更新数据库,
.原因：此消息有两个可能的原因：,
.* SQL语句引用了一个打包的PL / SQL函数，该函数不包含用于防止更新数据库的编译指示。,
.,
.* SQL语句引用独立的PL / SQL函数，其中包含更新数据库的指令。,
.,
.操作：如果引用的函数是打包的，PL / SQL函数：使用所需的编译指示重新创建PL / SQL函数; 一定要在编译指示的参数列表中包括“无数据库状态”（WNDS）参数。如果引用的函数是一个独立的PL / SQL函数：不要使用该函数。,
.

aiaiDBA

13718043309

010-86462881

ORA-06571: Function string does not guarantee not to update database

1 个回答

相似问题