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