OraFAQ Forum: Application Express, ORDS & MOD_PLSQL

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » how to find computer name (APEX 3.1.2, Oracle database 10g XE)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to find computer name [message #393950]

Wed, 25 March 2009 03:06

dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka

Senior Member

how to find computer name in Apex

Report message to a moderator

Re: how to find computer name [message #393961 is a reply to message #393950]

Wed, 25 March 2009 03:43

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

Report message to a moderator

Re: how to find computer name [message #393968 is a reply to message #393961]

Wed, 25 March 2009 04:17

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

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

provided you have proper permissions, v$session should work.

Report message to a moderator

Re: how to find computer name [message #395229 is a reply to message #394356]

Tue, 31 March 2009 15:25

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 08:44:35 CDT 2024