Dear All
We created a webservice in Oracle apex to download files using wsdl provided to us. The webservice will return filecontent as byte arrays. We are storing the output in a clob database column. Then using UTL_ENCODE.base64_decode(UTL_RAW.cast_to_raw utility we are converting the filecontent to original xml file format and then creating an xml file in the specified directory created by us. This much is working fine.
Our issue is somethimes webservice returns zipped filecontent instead of original content. This case we need to get the original content from zipped content and then create files based on original content. We are not successful in getting the original content.
Can you suggest any method to accomplish this. I tried utl_compress.lz_uncompress built -in procedure. But this is throwing ORA-29294: A data error occurred during compression or uncompression.
Thanks