Check if UTL_HTTP exists:
I have seen on the internet someone complain about not existing "UTL_HTTP"
Login do sqlplus:
Create ACL, you need this if yo are using 11g or up:
Check if we have ACL created:
ORA-24247: network access denied by access control list (ACL)
I have seen on the internet someone complain about not existing "UTL_HTTP"
SELECT * FROM dba_objects WHERE object_name='UTL_HTTP'
Login do sqlplus:
sys as sysdba
Grant execute to user, in my case im using system user (I know bad idea):
GRANT EXECUTE ON SYS.UTL_HTTP TO system;
Create ACL, you need this if yo are using 11g or up:
pay attention to principal it has to be UPPERCASE, if not it will give you "ORA-44416 Unresolved Principal" error
BEGIN DBMS_NETWORK_ACL_ADMIN.create_acl( acl => 'http_connect.xml', description => 'ACL that lets me talk to the my web server', principal => 'SYSTEM', is_grant => TRUE, privilege => 'connect' ); DBMS_NETWORK_ACL_ADMIN.assign_acl( acl => 'http_connect.xml', HOST => 'maks.tk', lower_port => 80, upper_port => 80 ); COMMIT; END;
Check if we have ACL created:
SELECT * FROM dba_network_acls;
ORA-24247: network access denied by access control list (ACL)
Comments
Post a Comment