Skip to Main Content

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!

List Sys_Context Parameter Values

Mark WagonerApr 4 2013 — edited Apr 4 2013
I have a package that is storing values in a system context so they they can be shared by all sessions without the overhead of constantly querying a table. My question is, after I have a number of name-value pairs to the context, is there some way I can get a list of the parameter names defined withint he context?

All of the examples I have found in the docs use USERENV as the context and retrieve the values using a known list of names. I need some way to get all of the parameters without necessarily knowing the name beforehand.

Thanks
This post has been answered by unknown-7404 on Apr 4 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2013
Added on Apr 4 2013
7 comments
558 views