Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » how to find computer name (APEX 3.1.2, Oracle database 10g XE)
how to find computer name [message #393950] Wed, 25 March 2009 03:06 Go to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

how to find computer name in Apex
Re: how to find computer name [message #393961 is a reply to message #393950] Wed, 25 March 2009 03:43 Go to previous messageGo to next message
andi_raj
Messages: 55
Registered: February 2008
Member
hi,
Normally you can find computer name by right clicking My Computer and then properties, you can find your computer name.
raj
Re: how to find computer name [message #393968 is a reply to message #393961] Wed, 25 March 2009 04:17 Go to previous messageGo to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

sorry !! raj i think i could not make you understand my problem? Smile actually i want to find the computer name (example: client computer name who using my apex application) by a query. i want to detect that computer name programatically and use it for security and so many purposes.


---Regards,

kamal

[Updated on: Wed, 25 March 2009 04:56]

Report message to a moderator

Re: how to find computer name [message #394356 is a reply to message #393968] Thu, 26 March 2009 10:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
provided you have proper permissions, v$session should work.
Re: how to find computer name [message #395229 is a reply to message #394356] Tue, 31 March 2009 15:25 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Call owa_util.print_cgi_env in a (PL/SQL block) to print all the CGI variables passed from HTTP server to PL/SQL environment. It varies depending on PL/SQL gateway version.

Once you have the variable name you want, you can access it directly using get_cgi_env e.g. OWA_UTIL.get_cgi_env('REMOTE_ADDR')

[Updated on: Tue, 31 March 2009 15:25]

Report message to a moderator

Previous Topic: How to change column header font-size
Next Topic: problem with oracle apex 3.1.1 object browser
Goto Forum:
  


Current Time: Sat Dec 10 18:43:52 CST 2016

Total time taken to generate the page: 0.06667 seconds