Home » SQL & PL/SQL » SQL & PL/SQL » how to find terminal and session id from weblogic.
how to find terminal and session id from weblogic. [message #36985] Wed, 09 January 2002 01:14 Go to next message
GOVINDARAJAN
Messages: 3
Registered: January 2002
Junior Member
I would like to know, how to get the terminal or session id in oracle database. The connection to the oracle server (Sun solaris box) is through web logic(middle tier server). if I use the following sql in my bean (EJB) i am getting 'unknown' as a result.

Select userenv('terminal') from dual;

where as when I run the same in sql prompt I am getting the correct terminal id.

Any one can help me to solve this problem.

Thanks in advance..

Govindarajan. K
Re: how to find terminal and session id from weblogic. [message #36997 is a reply to message #36985] Wed, 09 January 2002 12:24 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
try this when you connected through weblogic.

select SYS_CONTEXT('userenv','proxy_user'),
sys_context('userenv','OCI_ATTR_PROXY_CREDENTIALS')

from dual;
Re: how to find terminal and session id from weblogic. [message #37004 is a reply to message #36997] Wed, 09 January 2002 21:28 Go to previous message
GOVINDARAJAN
Messages: 3
Registered: January 2002
Junior Member
Hi,

Thanks for ur immediate response. But I am getting 'ORA-02003: invalid USERENV parameter' error . I am using oracle 8.0.5. Please let me why this error is coming.

Thanks in Advance

Regards

Govindarajan.k
Previous Topic: Help on Triggers
Next Topic: parameters for pl/sql procedure
Goto Forum:
  


Current Time: Thu Aug 06 09:10:57 CDT 2020