Re: reading CLOB with a PL/SQL Procedure
From: Jeff <jeff_at_work.com>
Date: Fri, 05 Oct 2001 12:24:03 GMT
Message-ID: <9pk8p3$kl$1_at_cronkite.cc.uga.edu>
Date: Fri, 05 Oct 2001 12:24:03 GMT
Message-ID: <9pk8p3$kl$1_at_cronkite.cc.uga.edu>
Perhaps it's a limitation of the dbms_lob package that you can only read in 4k chunks? Does the error occur within dbms_lob?
In article <3BBD50FC.707_at_schaefer-shop.de>, Markus Boehmer
<markus.boehmer_at_schaefer-shop.de> wrote:
>Hi folks,
>My problem is, that I get the Oracle Error ORA-06502.
>The version of the DB is 8.1.5 on solrais.
>It says, that the String buffer is too small if the length of the
>CLOB exceeds 4k.
>Writing works with values having a length of over fourthousand
>characters.
>Reading only works with values having a length of less than
>fourthousand characters.
>Has anyone a clue how to handle this?
>
>Greetings
>Markus
>
Received on Fri Oct 05 2001 - 14:24:03 CEST