I have written following code to call Report Using External Report Web service but it is showing error. Please help me.
declare
l_envelope CLOB;
l_xml XMLTYPE;
BEGIN
l_envelope:='
<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<soap:Header/>
<soap:Body>
<pub:runReport>
<pub:reportRequest>
<pub:reportAbsolutePath>/Custom/Supply Chain Management/Wholesale Process/Item Type Listing Report.xdo</pub:reportAbsolutePath>
<pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>
</pub:reportRequest>
<pub:appParams/>
</pub:runReport>
</soap:Body>
</soap:Envelope>';
l_xml:=apex_web_service.make_request(
p_url => 'https://xyz.com/xmlpserver/services/ExternalReportWSSService',
p_envelope => l_envelope,
p_username => 'abcd',
p_password => 'xyz12345');
dbms_output.put_line('Request has been submitted'||chr(10)||l_xml.getStringVal());
exception
when others then
dbms_output.put_line(SQLERRM);
END;
Error Message:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00217: invalid character 31 (U+001F)
Error at line 4
ORA-06512: at "SYS.XMLTYPE", line 5
ORA-06512: at "APEX_050000.WWV_FLOW_WEBSERVICES_API", line 200
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00217: invalid character 31 (U+001F)
Error at line 1