1 Reply Latest reply on Mar 2, 2017 8:35 PM by mdtaylor

    How to get client or end user's Terminal Name alongwith IP address in Forms 10g to be used in EBS Custom Forms?


      I am trying sys_context, but it return the database server host and ip like below.



        v_client_ip           varchar2(20);

        v_client_terminal varchar2(20);


        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.