Could you please post the code for your SP? Thanks.
>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
Mark McCasland
Midlothian, TX USA