sys_context to get client info [message #503623] |
Mon, 18 April 2011 07:46 |
|
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 #503699 is a reply to message #503684] |
Tue, 19 April 2011 01:22 |
|
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
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
|
|
|
|
|
|
|
|