ORA-24247 And ORA-29273 Errors

I have been reported the next stack error ;

ERROR en línea 1:
ORA-29273: fallo de la solicitud HTTP
ORA-24247: acceso de red denegado por la lista de control de acceso (ACL)
ORA-06512: en "SYS.UTL_HTTP", línea 1491
ORA-06512: en línea 1

The developer team send me the query that produces the error, it is the next;

set def off
select substr(UTL_HTTP.request('http://validate.sandbox.test2.es/services/sendmailing.phpmailingcode=M00241755&audienceid[CustomerID]=Email&fields[EMAILS]=xxxx@xxxxxxx.xx') ,1,4000) from dual;
set def on

In this case the problem is the acl privileges, the user executing the sentence hasn’t enough privileges, in this version (12.1.0.2) it can be solve by grant connect permission like show below;

 
BEGIN                                                                            
  DBMS_NETWORK_ACL_ADMIN.append_host_ace (                                       
    host       => 'validate.sandbox.test2.es',                         
    lower_port => 1,                                                             
    upper_port => 1500,                                                          
    ace        => xs$ace_type(privilege_list => xs$name_list('connect'),         
                              principal_name => 'USER_STEVEN',                         
                              principal_type => xs_acl.ptype_db));               
END;                                                                             
/                                                      

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s