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

PRAGMA RESTRICT_REFERENCES (YourFunctionName,WNDS,WNPS);

HTH Philippe

Sridhar Iyer <iyers_at_simpl.co.nz> wrote in article <6po4en$dk4$1_at_news.iconz.co.nz>...
> 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 Thu Jul 30 1998 - 07:11:38 CDT