Re: In PL SQL, an uncompress of a too big file raise an error

binpush3_at_gmail.com wrote:
> Hello,
> I try to uncompress file using the commands utl_compress.lz_uncompress.
> I manage to uncompress small file, lesser than a blob max size.
> But when I test the program with a bigger file, I'm having the error ORA-29294: A data error occurred during compression or uncompression.
>
> I don't manage to test the size of the blob, before the command "utl_compress.lz_uncompress".
>
> I have put some dbms_output to follow what happens. Here is the results when just before the error raise :
>
> SH.20150402182321.dat.gz ouvert
> taille_restant_1309178
> taille_a_lire_32000
> postion_lecture_32001
> taille_restant_1277178
> taille_a_lire_32000
> postion_lecture_64001
>
> I don't know what to do more, help !
>
> Ben
> contenu_decompresse_ RAW (32000);
> contenu_lu_ RAW (32000);
> --
> contenu_decompresse_ := utl_compress.lz_uncompress (contenu_lu_);
>

Are you really trying to "uncompress" 32000 characters into 32000 characters, or am I missing something? Received on Sun Sep 06 2015 - 22:12:19 CEST