see sys_context and dbms_session.set_context if you are using oracle 8i.

Note: I am not very sure, whether it is applicable to your situation