I tried to use UTL_HTTP with generated pdf from query report which is made using rtf file( BI pupplisher),
I created page to disply the report, and use the page url to add xml script to the pdf file,
but i always receive error message
(ORA-29273: HTTP request failed)
(ora_sqlcode: -29273
ora_sqlerrm: ORA-29273: HTTP request failed
ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 55
ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 126
ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2654
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 1148 ORA-06512: at line 37
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 837
ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2614
ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 97
ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 430
ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC", line 614
ORA-06512: at "APEX_220200.WWV_FLOW_EXEC_LOCAL", line 3053
ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2642
ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2678
ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 34
ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 1230
ORA-06512: at "APEX_220200.WWV_FLOW_PLUGIN", line 3163
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 62841056118348574801)
could you help me to solve this problem .. thanks in advance
Part of Code
url :='https://apex.oracle.com/pls/apex/r/UserArea/AppName/testdirectreport?session=&SESSION.';
v_req := UTL_HTTP.begin_request (url, 'POST', ' HTTP/1.1');
UTL_HTTP.set_header (v_req, 'content-type', 'application/xml');
UTL_HTTP.set_header (v_req, 'charset', 'UTF-8');
UTL_HTTP.set_header (v_req, 'Content-Length', LENGTH (var));
reqlength := DBMS_LOB.getlength (var);