ORA-06571 and PLS-00452

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.

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 Received on Thu Mar 04 1999 - 00:00:00 CET