Sunday, 5 February 2012

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 or SQL function that does not contain a pragma that prevents the database from being updated. * A SQL statement references a stand-alone, PL or SQL function that contains an instruction to update the database.

Action: If the referenced function is a packaged, PL or SQL function: Recreate the PL or 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 or SQL function: Do not use the function.

No comments:

Post a Comment