ora_client_ip_address

VARCHAR2

Returns the IP address of the client in a LOGON event, when the underlying protocol is TCP/IP
if (ora_sysevent = 'LOGON')
then addr := ora_client_ip_
address;
end if;


select sys_context('userenv','ip_address')
from dual;