Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get client or end user's IP address (IPV4 ) in Forms 12c

Marwan IdreessNov 24 2017 — edited Nov 28 2017

I create This function at sql developer

CREATE OR REPLACE FUNCTION FIND_IPADDRESS return CHAR IS

V_IP VARCHAR2(50);

BEGIN

select sys_context('userenv','ip_address') into v_ip from dual;

return v_ip;

END;

at sql developer when I run

select FIND_IPADDRESS from dual;

I get client ip v4 address

but at Form webutil when I run MESSAGE('IP ' || FIND_IPADDRESS ); I get server ip v6 address

do you have to do to get Client IP at Form 12c

Regards

Marwan

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2017
Added on Nov 24 2017
7 comments
1,796 views