All geek questions in one place

How to get PC local IP address in Oracle ApEx

Hoping this is possible and someone can help, but I need a tool to get the local IP address (the Windows window specified in the ipconfig command information) from Oracle ApEx.

Is this possible, since I have tried both owa_util.get_cgi_env('REMOTE_ADDR'), andsys_context( 'userenv', 'ip_address' )

It just fails to get my local pc ip address in Oracle ApEx.

Any ideas?

+3
source share
2 answers

To get the Oracle Client IP address , you must use the one you suggested:

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

To get the IP address of Oracle Server , you can use:

select utl_inaddr.get_host_address(sys_context('userenv','server_host')) 
  from dual;

( ):. IP- , , . ? . IP- -. Oracle Appex 100% PLSQL, .

+3

, , ipconfig IP- . 192.168.0.10, , .

, this this .

0

Source: https://habr.com/ru/post/1731808/

More articles:


All Articles