SQL & PL/SQL

Hi,

Under Oracle APEX 24 and Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.31.0.1.0.

I need to do some adujstments to the ACL. I have made this instruction successfully as ADMIN in the DB:

BEGIN
    dbms_network_acl_admin.Append_host_ace(host => 'api.apexofficeprint.com',
    ace => Xs$ace_type(privilege_list => Xs$name_list('connect'),
                  principal_name => 'APEX_240200'
           , principal_type => xs_acl.ptype_db));
END;

Then tried to run this script:

Then executed the script:

-- Generate PDF based on Word template
declare
 l_template blob;
 l_pdf      blob;
begin
 select BLOB_CONTENT
   into l_template
   from APEX_APPLICATION_FILES
  where FILENAME = 'AOP_TEMPLATE_Confirmation volunteering - medical - template.docx';
 l_pdf := aop_plsql_only_pkg.make_aop_request(
             p_aop_url   => 'https://api.apexofficeprint.com/',
             p_api_key   => '',
             p_template_type => 'docx',
             p_template  => l_template,
             p_data_json => q'!
                               [
                                 {
                                   "filename": "file1",
                                   "data": [
                                       {
                                         "NAME": "NAME 5",
                                         "ARRIVAL_DATE": "2/2/2026",
                                         "DEPARTURE_DATE": "3/2/2026"
                                       }
                                   ]
                                 }
                               ]              
             !',
             p_output_type => 'pdf'
           );
insert into aop_output (output_blob, filename, mime_type, last_update_date)
values (l_pdf, 'plsql_only_pdf.pdf', 'application/pdf', sysdate); 
end;
/

But I get an error message:

ORA-29273: HTTP request failed ORA-24247: Network access denied by access control list (ACL) ORA-06512: at "SYS.UTL_HTTP", line 380 ORA-06512: at "SYS.UTL_HTTP", line 1209 ORA-06512: at "WKSP_LESPIEDSBOTS.AOP_PLSQL_ONLY_PKG", line 187 ORA-06512: at line 9

I checked the ACL:

APEX_240200,"api.apexofficeprint.com",,,"NETWORK_ACL_4CE38D42FAE59AF5E063DF5A000A0592","resolve",""

Best regards.