CODEWITHSUNDEEP
oracle-databaseplsqloracle-apex
Arthur Barreto
Arthur Barreto

Reputation: 197

How can I get the remote client IP address using Oracle APEX?

Is it possible to get the remote client IP adress if I need to get this informantion to log a user activity by example?

PS.: I'm using Oracle APEX 4.2 version.

Upvotes: 3

Views: 7149

Answers (1)

Arthur Barreto
Arthur Barreto

Reputation: 197

In Oracle APEX you can get the remote client IP address using the OWA_UTIL package like the example bellow:

select owa_util.get_cgi_env ('REMOTE_ADDR') from dual;

As described in the documentation:

The OWA_UTIL package contains utility subprograms for performing operations such as getting the value of CGI environment variables [...].

OWA_UTIL

Upvotes: 6

Related Questions