Re: ORA-06571

lbt_at_terminator.rs.itd.umich.edu (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
>ORA-06571.
>--
>Bernard Tiffany
>Internet: Bernard.Tiffany_at_umich.edu CompuServe: 75046.2667
>"With malice toward none; with charity for all" Abraham Lincoln, March 4, 1865

Bernard,
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:                    <->
<->                                                               <->
<->              http://homepage.interaccess.com/~akaplan         <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->