General information
Title:
Function returns error ORA 06571.
I want to create simple stand-alone function, which will make Inserts or Updates.
But Oracle still returns ORA06571 ??
Why 'Do not use this function' ??
Pavel
>In server messages:
ORA-06571: function name does not guarantee not to update database
Cause: There are two possible causes for this message:
A SQL statement references a packaged PL/SQL function that does not contain a pragma that prevents the database from being updated.
A SQL statement references a stand-alone, PL/SQL function that contains an instruction to update the database.
Action: If the referenced function is a packaged PL/SQL function: Recreate the PL/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/SQL function: Do not use the function
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only