2 Replies Latest reply: Jul 25, 2011 8:38 PM by 877744 RSS

    "UTL_INADDR"."GET_HOST_ADDRESS": invalid identifier

    877744
      I am trying to use utl_inaddr.get_host_address from ORACLE 10.2, but i have got ORA-00904 error.

      SQL> SELECT global_name,utl_inaddr.get_host_address FROM global_name;
      SELECT global_name,utl_inaddr.get_host_address FROM global_name
      *
      ERROR at line 1:
      ORA-00904: "UTL_INADDR"."GET_HOST_ADDRESS": invalid identifier


      SQL>

      I have checked the web, but not much information about whats wrong with this error.

      Does anyone know what do i need to do to solve this problem.
      Many thanks
        • 1. Re: "UTL_INADDR"."GET_HOST_ADDRESS": invalid identifier
          mobra
          I am trying to use utl_inaddr.get_host_address from ORACLE 10.2, but i have got ORA-00904 error.
          Make sure the current schema has execute privilege on the package:
          -- run as SYS
          
          grant execute on utl_inaddr to your_schema_name;
          Seems that this was granted to PUBLIC in pre-11g versions of the database, but you need to grant it explicitly now.

          Note that you may also have to use the dbms_network_acl_admin package to control network privileges at a fine-grained level:

          http://www.davidlitchfield.com/blog/archives/00000025.htm



          - Morten

          http://ora-00001.blogspot.com
          • 2. Re: "UTL_INADDR"."GET_HOST_ADDRESS": invalid identifier
            877744
            many thanks for the help. i found out that the package was not installed on 10.2. so i need to run the file @?/rdbms/admin/catproc.sql as sysdba
            after that it worked.

            you are a super man.