ORA-06573: Function string modifies package state, cannot be used here

ORA-06573: Function string modifies package state, cannot be used here
Cause: There are two possible causes for this message:
* A SQL statement references a packaged, PL/SQL function that does not contain a pragma containing the 'Write no Package State' (WNPS).

* A SQL statement references a stand-alone, PL/SQL function that modifies a package state. A stand-alone, PL/SQL function referenced by a SQL statement cannot modify a package state.

Action: If the function is a packaged, PL/SQL function: Recreate the function and include a pragma containing the 'Write no Package State' (WNPS). If the function is a stand-alone, PL/SQL function: Delete the function from the SQL statement.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:38

ORA-06573：函数字符串修改包状态，不能在此处使用,
.原因：此消息有两个可能的原因：,
.* SQL语句引用一个打包的PL / SQL函数，该函数不包含包含“无写入包状态”（WNPS）的编译指示。,
.,
.* SQL语句引用了修改包状态的独立的PL / SQL函数。SQL语句引用的独立的PL / SQL函数无法修改程序包状态。,
.,
.操作：如果函数是一个打包的PL / SQL函数：重新创建函数并包含一个包含“无写入包状态”（WNPS）的编译指示。如果函数是独立的，PL / SQL函数：从SQL语句中删除函数。,
.

aiaiDBA

13718043309

010-86462881

ORA-06573: Function string modifies package state, cannot be used here

1 个回答

相似问题