ORA-29294 Raised When UTL_COMPRESS.LZ_UNCOMPRESS to decompress valid compressed data from a BLOB (Doc ID 1544982.1)

Last updated on FEBRUARY 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
PL/SQL - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Symptoms

Problem Description
---------------------------------------------------
I am running into an error when rusing utl_compress.lz_uncompress  to read and decompress compressed XML data from a BLOB column.

Ideally, I would be able to create PL/SQL code that uses utl_compress.lz_uncompress
  1. Read the LOB
  2. decompress it
  3. 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.

 

QUESTION

==========

Is this Oracle proprietary or known problem?

Changes

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

 

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms