OraFAQ Forum: Forms » getting curernt form hostname

Home » Developer & Programmer » Forms » getting curernt form hostname (RMS 9i)

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

getting curernt form hostname [message #506436]

Mon, 09 May 2011 05:08

orafaqsmheann23
Messages: 13
Registered: June 2010

Junior Member

Hi,

Would like to ask if you know how can I get the form hostname that it is currently running to?

I already tried the form's (forms developer 6i) built in host functionality but it doesn't return the hostname.

Our current approach is to have a shell script that will get and insert the hostname into the table and the form will just query from the table to get the hostname, but that approach has involved too many modules.

Need a hand on this. Is there an easiest way to get the hostname?

Thanks a lot,
Mheann

Report message to a moderator

Re: getting curernt form hostname [message #506439 is a reply to message #506436]

Mon, 09 May 2011 05:16

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

SELECT sys_context('USERENV', 'HOST') FROM dual;
SELECT sys_context('USERENV', 'SERVER_HOST') FROM dual;

Does the above helpful ?

Sriram

Report message to a moderator

Re: getting curernt form hostname [message #506444 is a reply to message #506439]

Mon, 09 May 2011 05:36

orafaqsmheann23
Messages: 13
Registered: June 2010

Junior Member

I think this is a database server, it we need the app server. if you're going to a unix box and type the 'hostname' and execute that value is what I needed. The hostname were the form is currently running. Would you know other ways?

Thanks a lot.

Report message to a moderator

Re: getting curernt form hostname [message #506445 is a reply to message #506444]

Mon, 09 May 2011 05:39

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The first one gives the Oracle client host, that is the application server.
The latter one gives the database server.

Regards
Michel

Report message to a moderator

Re: getting curernt form hostname [message #506447 is a reply to message #506445]

Mon, 09 May 2011 05:52

orafaqsmheann23
Messages: 13
Registered: June 2010

Junior Member

Tried it in the form and it returns null. Sad

Report message to a moderator

Re: getting curernt form hostname [message #506448 is a reply to message #506447]

Mon, 09 May 2011 06:02

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

http://www.dbforums.com/oracle/704715-d2kwutil.html

I guess d2kwutil.zip will help you.

Try that
Good luck

Sriram

Report message to a moderator

Previous Topic:	Anybody run Form 6i on Windows 7 ?
Next Topic:	How to send automated email from Oracle Form [merged by jd]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 08:16:47 CST 2025