Dbms_session

When I am trying to execute DBMS_SESSION.SET_CONTEXT, I am getting no privilege to execute SYS.DBMS_SESSION.SET_CONTEXT. I don't have access to SYS account. Is there a way to get around this by like asking the DBA to give some grant for me to execute etc.

Thanks,
PN

A context can only be accessed via a trusted procedure. This proc is specified when the context is created. E.g.

Define proc SetMContext. It serves as the trusted procediure for the context. Only it is allowed to call dbms_session.set_context to set name-values in M_CONTEXT.

Then you issue the following to create the context and bind its trusted procedure to it:
create or replace context m_context using SetMContext;

Hi.

I've got a couple of examples of using contexts here:

http://www.oracle-base.com/articles/...ngContexts.php
http://www.oracle-base.com/articles/...ts.php#context

Cheers

Tim...