Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Programming

 

ORA_CLIENT_IP_ADDRESS returns the client IP address as a VARCHAR2 datatype

SQL> SQL> DECLARE   2    ip_address VARCHAR2(11);   3  BEGIN   4    IF ora_sysevent = 'LOGON' THEN   5      ip_address := ora_client_ip_address;   6      dbms_output.put_line('ip_address:'||ip_address);   7   8    END IF;   9  END;  10  / PL/SQL procedure successfully completed. SQL>