ORA-06571 function name does not guarantee not to update database: pragma

Hi,

I get this message when I use a packaged function.

> ORA-06571 function name does not guarantee not to update database

The cause and action documented by Oracle is as given below:

>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.

But the manuals don't tell you the syntax for such pragmas. I have used pragmas to declare and handle exception codes.

Can anyone help ??? Received on Wed Jul 29 1998 - 16:39:46 CDT