If you need to get a users IP address in PLSQL or Oracle Application Express you can use the following syntax :

l_ip := owa_util.get_cgi_env('REMOTE_ADDR');