标题: ORA-06574: Function string references package state, cannot execute remotely [打印本页] 作者: admin 时间: 2016-7-27 15:38 标题: ORA-06574: Function string references package state, cannot execute remotely ORA-06574: Function string referencespackage 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-alonefunction
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 anINSERT
statement, or SET clause of an UPDATE statement can modify a package state. Action: Ifthe 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 callthe
function.