| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-06571 error... HELP!
Hi
About your question to Oracle Group this is information I have on my server
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.
Hope this help
Marcos
Luis Díez Porres wrote:
> Hi, this is the same post as another one I posted five minutes ago....
> just in case you know that ORA error.
>
> I need to develop a PL/SQL function that allows me to insert/update a
> table.
> I'm getting an
>
> ORA-06571: function name does not guarantee not to update database
>
> How is I cannot update the database?
> Do I need to change any initialization parameter?
>
> It has to be a function, not a procedure, cause we're working through a
> third party product.
>
> Thanks in advance.
>
> --
> ________________________________
>
> Luis Diez Porres
>
> Jefe de Sistemas
> Cuende Asociados
>
> Pº Castellana, 135 Pta.17ª
> 28046 - Madrid (Spain)
>
> Email: luis_at_cuende-asociados.es
> Tfno: (34-1) 449-2980
> Fax: (34-1) 449-2971
> ________________________________
>
--
"Smell the Flower While you can"
 |
 |