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

Hi,

  If you have PL/SQL Programming by Scott Urman ( Oracle Press ), read chapter 8. It discusses pragmas in detail.

Hope this helps,
Srinivas.Chikka

Sridhar Iyer wrote in message <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 Sun Aug 02 1998 - 22:00:58 CDT