IP can be found out with this...

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

HTH

SS