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: