Re: ORA-06571 and PLS-00452

A copy of this was sent to "Thomas Schmitt" <tomschmitt_at_mediaone.net> (if that email address didn't require changing) On Thu, 4 Mar 1999 20:45:13 -0600, you wrote:

>I have a package with two functions, one of which uses two cursors – neither
>of which updates any tables. When I execute it I get a error message --
>ORA-06571 Function MyFunc does not guarantee not to update database. I added
>PRAGMA RESTRICT_REFERENCES( MyFunc, WNDS ) to the package specification.
>Then when I compile the package body I get a compile error -- PLS-00452:
>Subprogram 'MyFunc' violates its associated pragma.
>

gotta see the code. does myfunc or your package reference another package? if so, is the purity on that package set?

also, add a

pragma restrict_references( YOUR_PACKAGE_NAME, wnds );

to the head of the package and see if the package is 'pure' as well.

>We're using Oracle 7 Server Release 7.3.4.3.0 with the 64 bit option.
>
>What am I doing wrong??
>
>Thanks,
>Tom Schmitt
>
>
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation