I am trying sys_context, but it return the database server host and ip like below.
select SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) into v_client_ip from dual;
select SYS_CONTEXT('USERENV', 'HOST', 15) into v_client_terminal from dual;
Above procedure returns Client IP and Client Terminal in Toad or SqlPlus, but in ebs forms, same procedure shows database (12c) server host name and IP address.
Also tried UTL_INADDR.GET_HOST_NAME & UTL_INADDR.GET_HOST_ADDRESS, but this function return database server in both SqlPlus and EBS custom forms.
Need to get client IP and terminal name in forms 10g.
Sys_Context works perfectly fine in Oracle Forms 6i both in SqlPlus and Forms 6i running with database 11g.