OraFAQ Forum: Forms » How to get ip address in forms 6i

Home » Developer & Programmer » Forms » How to get ip address in forms 6i

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

How to get ip address in forms 6i [message #573600]

Mon, 31 December 2012 12:27

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

How to get ip address in forms 6i

Regards

Faheem

Report message to a moderator

Re: How to get ip address in forms 6i [message #573601 is a reply to message #573600]

Mon, 31 December 2012 12:33

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Whose IP address?

Report message to a moderator

Re: How to get ip address in forms 6i [message #573602 is a reply to message #573601]

Mon, 31 December 2012 12:37

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

Client Computer ip

Report message to a moderator

Re: How to get ip address in forms 6i [message #573603 is a reply to message #573602]

Mon, 31 December 2012 12:44

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Here you go: select SYS_CONTEXT with the following parameters (I don't have Forms here, so I'm showing you a function approach).

SQL> create or replace function f_ip return varchar2 is
  2  begin
  3    return sys_context('userenv', 'ip_address');
  4  end;
  5  /

Function created.

SQL> select f_ip from dual;

F_IP
--------------------------------------------------------
xxx.yyy.zzz.www

SQL>

Report message to a moderator

Re: How to get ip address in forms 6i [message #573604 is a reply to message #573603]

Mon, 31 December 2012 12:59

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

sys_context not support to forms 6i

Report message to a moderator

Re: How to get ip address in forms 6i [message #573605 is a reply to message #573604]

Mon, 31 December 2012 13:16

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

in this command i get terminal name easily

SELECT USERENV('TERMINAL' ) into :global.terminals FROM DUAL;

but when i change this command to get ip_address then forms return error the command is

SELECT USERENV('IP_ADDRESS' ) into :global.IP FROM DUAL;

Report message to a moderator

Re: How to get ip address in forms 6i [message #573606 is a reply to message #573604]

Mon, 31 December 2012 14:51

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

qanita786 wrote on Mon, 31 December 2012 19:59

sys_context not support to forms 6i

Create a database function and call it from your form; what is the result, then?

Report message to a moderator

Previous Topic:	Problem with trigger when-validate-item
Next Topic:	Display All records of my DB in a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 12:34:57 CDT 2024