Last updated on FEBRUARY 15, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 188.8.131.52 [Release 10.1 to 11.2]
PL/SQL - Version 10.1.0.2 to 184.108.40.206 [Release 10.1 to 11.2]
Information in this document applies to any platform.
I am running into an error when rusing utl_compress.lz_uncompress to read and decompress compressed XML data from a BLOB column.
- Read the LOB
- decompress it
- load it into an XML table -- without extracting the data to disk
Attempts to read and uncompress the compressed XML using utl_compress.lz_uncompress, as shown in the below code, generates an error (error message follows PL/SQL code) during the uncompress operation.
The data in the BLOB column is a valid compressed file.
I am able to:
1) extract the BLOB data through SQL Developer by double clicking on the (BLOB) column
selecting "Download" -- and uncompressing the saved file with any of 7-Zip, Winzip, or Windows based compressed folder,
2) extracting the BLOB data with a java program and saving it to disk, then uncompressing with the previously mentioned tools.
Is this Oracle proprietary or known problem?
No known change : the problem appears to be server neutral and has reproduced using 11.2.x on various servers
Here is the example showing the problem
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms