Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » sys_context to get client info
sys_context to get client info [message #503623] Mon, 18 April 2011 07:46 Go to next message
Grim
Messages: 4
Registered: April 2011
Junior Member
Hi,

I'm trying to use sys_context info to get the session info. I have a procedure in the base, which returns a string with the info. This procedure is called from oracle forms.

The problem I have is, since this procedure is called from the application server, the data returned is that of the application server, not the client.

I suppose one way would be to call sys_context directly from the forms rather than trough a stored procedure, but I had some problems with that.

Any ideas oh how to get over this?
Re: sys_context to get client info [message #503684 is a reply to message #503623] Tue, 19 April 2011 00:51 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Maybe, if you specify which "problems" you are talking about.
Re: sys_context to get client info [message #503699 is a reply to message #503684] Tue, 19 April 2011 01:22 Go to previous messageGo to next message
Grim
Messages: 4
Registered: April 2011
Junior Member
Can't give you details on that "problem" yet, as it seems to be working for some users, but not for the rest. I'll look into it and come back to you on that Smile

The main question tho is, if I can call sys_context in a stored procedure and get session info on the client (the one using forms), not the application server.

[Updated on: Tue, 19 April 2011 01:23]

Report message to a moderator

Re: sys_context to get client info [message #503712 is a reply to message #503699] Tue, 19 April 2011 01:59 Go to previous messageGo to next message
Grim
Messages: 4
Registered: April 2011
Junior Member
OK, the error I get when trying to run the sys_context() on the forms is: ora-32767 - No server connection for this operation.
It's working on 10g but gives (ora-32767) on 11g.
Re: sys_context to get client info [message #503721 is a reply to message #503712] Tue, 19 April 2011 02:15 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't use Forms 11g so ... can't even test it.

I did some Googling and visited My Oracle Support (MOS) - didn't find anything useful; there was a document on MOS that talks about ORA-32767 and "forms", but not directly about SYS_CONTEXT which suggests that the procedure should be stored and called from a form (which, obviously, isn't what you are after).

Sorry, can't help much.
Re: sys_context to get client info [message #503723 is a reply to message #503721] Tue, 19 April 2011 02:17 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://forums.oracle.com/forums/thread.jspa?threadID=935071

Does it helpful ?
Sriram
Re: sys_context to get client info [message #504026 is a reply to message #503723] Thu, 21 April 2011 03:14 Go to previous messageGo to next message
Grim
Messages: 4
Registered: April 2011
Junior Member
OK, so I moved all the sys_context calls to the forms but it still returns application server info.
For example: sys_context('USERENV','OS_USER') will return the username application server uses, I'd like to get the username the form user used to log to the OS.
Can that be done with sys_context()?
Re: sys_context to get client info [message #504066 is a reply to message #504026] Thu, 21 April 2011 06:59 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Similar Posts found here.search for that.
Keywords: "client info using forms" By djmartin.

Sriram
Previous Topic: Migration of Oracle Application Server 10g to Application Server 9i
Next Topic: forms 10g not running on WLS
Goto Forum:
  


Current Time: Thu Mar 28 21:20:43 CDT 2024