-- an example for returning the web user's IP address with PL/SQL web toolkit

PROCEDURE p_test
IS
BEGIN
   HTP.PRINT
      (   'Your IP address is: '
       || OWA_UTIL.get_cgi_env ('REMOTE_ADDR')
       || ''
      );
END;