Re: ORA-06571 error..

06571, 00000, "Function %s 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.

You need to put a PRAGMA information into the package structure just under the declaration of the function.

> I try to run PL/SQL procedure.
> And get an error message:
>
> "ORA-06571: Function MONEY_TO_CHAR does not guarantee not to update
> database"
>
> Manual recommends "include the 'Write No Database State' (WNDS) argument
 in
> the argument list of the pragma."
>
> What does it mean???
>
> Thanks in advance.
>
> Danil Krasnov
> danil_at_maginfo.net
>
  Received on Fri Sep 11 1998 - 00:00:00 CDT