SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to determine purity level

510282May 2 2006 — edited May 3 2006

Hi everybody!
Oracle determines purity levels of each stored procedure/function during validation/compilation. We can also set it "manually" by using pragma_restrict declarations.
For certain dynamic maintenance processes we need to know the situation...

Where is it stored? Is there a simple way to query it from some system view rather than to try executing "select my_function(my_arguments) from dual" and encount "ORA-06571: Function MY_FUNCTION does not guarantee not to update database"

I have searched for some for the answer. However have not discovered any easy way to determine (query) it.

Any suggestions are welcome, thanks in advance...

Jaan

Locked Post

New comments cannot be posted to this locked post.

Locked on May 31 2006

Added on May 2 2006

3 comments

408 views