This content has been marked as final. Show 4 replies
Specific to APEX, you can use the v function to access APEX session state information (i.e. v('APP_USER') to get the currently logged in application user).
If you are going to use a global context, you would need a session ID (or something similar) that is stored as a part of the global context to determine which session you are interested in. The global context would have A's data with A's session ID and B's data with B's session ID and before you get the context information, you would need to specify which session ID you are asking about.
Tom Kyte has an example of using a global context
Oh man, this is really great ...!
The link is very educational....!
So if i understood clearly, say you need to set a global context, and continuing with my example, suppose you have two companies in one database, it means you will need to set two groups of context values, one for each company. What one needs to do is to have a init procedure that sets contexts for both companies, and through the use of a session id or something map to the correct set of values. Is this correct ....?
Regards, Luis ...:)
Right. The global context would have the context for each session and you would need some session-specific identifier (i.e. a session ID) to act as a key so that you can retrieve the appropriate context values for a particular session.
Thanks a lot. Again.
Very helpful ....!
Best regards, Luis ....! :)