HI - I am using the web service call using apex_web_service.make_request to invoke a BIP , but the base64 encode response returned is not complete. I tried to test the same payload in SOAPUI and it returns complete base64 encode value but not in APEX. The BIP returns 50K records. is there any limitation when called from APEX? Below is the sample payload I am using
-------------------------------------------
l_envelope:='
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">
<soapenv:Header/>
<soapenv:Body>
<v2:runReport>
<v2:reportRequest>
<v2:attributeFormat>csv</v2:attributeFormat>
<v2:flattenXML>false</v2:flattenXML>
<v2:reportAbsolutePath>'||l_reportpath||'</v2:reportAbsolutePath>
<v2:sizeOfDataChunkDownload>-1</v2:sizeOfDataChunkDownload>
</v2:reportRequest>
<v2:userID><username></v2:userID>
<v2:password><password></v2:password>
</v2:runReport>
</soapenv:Body>
</soapenv:Envelope>';
l_envelope1:=APEX_WEB_SERVICE.CLOBBASE642BLOB (
apex_web_service.parse_xml_clob( apex_web_service.make_request(
p_url => 'https://fa-eqsg-dev9-saasfaprod1.fa.ocs.oraclecloud.com/xmlpserver/services/v2/ReportService',
p_envelope => l_envelope,
p_username => 'Susername',
p_password => 'password')
,
'//*:reportBytes/text()'
)
);
l_envelope:=apex_web_service.BLOB2CLOBBASE64(l_envelope1);
----------------------------------------------------------
if I insert the l_envelope into a table having clob column and query the table, I see the base64 encode in the table but its not complete value
Pls help me understand if this is a limitation in APEX