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> SQL>