Subject: Re: ORA-06571
References: <5lfvc4$q3i$> (Lyle B Tiffany) writes:
>Oracle claims the following with the message "ORA-06571: Function XXX does
>not guarantee not to update database".
>   select XXX('one', 'two') from dual;
>But the function XXX does not really update any databases.  How in the world
>can I fool the Oracle?  The manual I have does not have the message number
>Bernard Tiffany                      
>Internet:                     CompuServe: 75046.2667 
>"With malice toward none; with charity for all" Abraham Lincoln, March 4, 1865

According to my documentatoion

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.

-Ari Kaplan
Independent Oracle DBA Consultant

<-> For 60+ technical tips, visit my Web Page:                    <->
<->                                                               <->
<->                                    <->
<->                                                               <->
<->             email:                    <->

Back to Ari Kaplan's Home Page ">Back to Ari Kaplan's Home Page