ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-06574

ORA-06574

原创 Linux操作系统 作者:xin2v 时间:2009-03-19 14:26:31 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(,WNDS,WNPS,RNDS,RNPS);",below the "create ... as " sentences,or  put a line "pragma restrict_references(,WNDS,WNPS,RNDS,RNPS);"  following the function declarings

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10325341/viewspace-573090/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-03-19

  • 博文量
    45
  • 访问量
    65665