Re: Dynamic SQL and function purity

Cancel the request for an explanation of DBMS_SQL and RESTRICT_REFERENCES. I found where this was covered thoroughly in a thread "ORA-06571 error using DBMS_SQL in PL/SQL function" started by Robert Goodwin in November 1995. (Deja News is wonderful!)

Suggestions for workarounds still welcomed.

Brian Gastineau <bgastine_at_giveblood.org> wrote in article <01bc5bfc$9b81ea00$b90110ac_at_gastineau1.giveblood.org>...
> I am having difficulty creating a package with functions for use in SQL
> statements. It appears that the DBMS_SQL package violates the
> RESTRICT_REFERENCES(WNDS) pragma. Is this correct? It would make sense
 to
> me since the PL/SQL compiler can't confirm that the package won't change
> the database.
>
> Pointers to workarounds appreciated.
>
> Thanks,
> Brian
> bgastine_at_giveblood.org
>
Received on Thu May 08 1997 - 00:00:00 CDT