ORA-06574

最新推荐文章于 2022-05-17 12:00:39 发布

木划离

最新推荐文章于 2022-05-17 12:00:39 发布

阅读量838

点赞数

分类专栏： OracleDB 文章标签： function include reference insert action string

本文链接：https://blog.csdn.net/compard/article/details/1906568

版权

OracleDB 专栏收录该内容

47 篇文章 0 订阅

订阅专栏

ORA-06574:

Function string references package state, cannot execute remotely

Cause:

There are two possible causes for this message:

* A remote, packaged function or a remote-mapped, local, packaged function that does not contain a pragma with the 'Write no Package State' (WNPS) and 'Read no Package State' (RNPS) arguments references a package state.

* A remote, stand-alone function or a remote-mapped, local, stand-alone function contains a reference to a package state (reads or writes a package variable). Only local functions that are referenced in a SELECT list, VALUES clause of an INSERT statement, or SET clause of an UPDATE statement can modify a package state.

Action:

If the function is a packaged function: Recreate the function and include a pragma containing the 'Write no Package State' (WNPS) and 'Read no Package State' (RNPS) arguments. If the function is a stand-alone function: Do not call the function.

Rereate the function as a member of package,then include a pragma with "pragma restrict_references(<PKGName>,WNDS,WNPS,RNDS,RNPS);",below the "create ... as " sentences,or put a line "pragma restrict_references(<FUNName>,WNDS,WNPS,RNDS,RNPS);" following the function declarings.