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?

    3406942

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

       

      declare

        v_client_ip           varchar2(20);

        v_client_terminal varchar2(20);

      begin

        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;

      end;

      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.

       

      Thanks

      Kaisar