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

Le dimanche 6 septembre 2015 22:12:30 UTC+2, A. Mehoela a écrit :
> 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?

Hello,
no, I'm trying to uncompress a file with a size greater than 32000 characters. I want to put the content into a text file that has the necessary size (greater than 32000). Received on Mon Sep 07 2015 - 10:56:28 CEST