This content has been marked as final. Show 2 replies
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:
Seems that this was granted to PUBLIC in pre-11g versions of the database, but you need to grant it explicitly now.
-- run as SYS grant execute on utl_inaddr to your_schema_name;
Note that you may also have to use the dbms_network_acl_admin package to control network privileges at a fine-grained level:
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.