Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Web services with PL/SQL, ORA-24244 error

unknown-879931Apr 29 2014 — edited Apr 30 2014

Hi Experts,

I am just trying to use web services via PL/SQL. So I executed the following block, it works without error. However when I use the DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL procedure, it gives ORA-24244 error. I have to use https://tckimlik.nvi.gov.tr/Service/KPSPublic.asmx link web service. https://tckimlik.nvi.gov.tr/Service/KPSPublic.asmx?op=TCKimlikNoDogrula

What can I do? Do you have any idea?

set serveroutput on;

BEGIN

  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl         => 'www.xml',

                                    description => 'WWW ACL',

                                    principal   => 'HR',

                                    is_grant    => true,

                                    privilege   => 'connect');

  DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl       => 'www.xml',

                                       principal => 'HR',

                                       is_grant  => true,

                                       privilege => 'resolve');

END;

>> anonymous block completed

BEGIN

  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl  => 'www.xml',

                                    host => 'https://tckimlik.nvi.gov.tr/Service/KPSPublic.asmx?op=TCKimlikNoDogrula');

END;

Error report:

ORA-24244: invalid host or port for access control list (ACL) assignment

ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 164

ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 485

ORA-06512: at line 3

Thanks in advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2014
Added on Apr 29 2014
4 comments
2,007 views