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

From: A. Mehoela <a.mehoela_at_hoetmeel.com>
Date: Mon, 07 Sep 2015 21:03:40 +0200
Message-ID: <hclHx.262938$i22.113389_at_fx05.am4>


bin ush wrote:
> Le dimanche 6 septembre 2015 22:12:30 UTC+2, A. Mehoela a écrit :
>> binpush3_at_gmail.com wrote:
>>> 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).
>
I'll try once more: look at the lines I copied from your code, once you're awake.

You ARE trying to uncompress 32000 bytes into a variable that can also only hold 32000 bytes. Received on Mon Sep 07 2015 - 21:03:40 CEST

Original text of this message