Dynamic SQL and function purity

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