Re: CLOB > 32k
From: Frank van Bortel <fbortel_at_home.nl>
Date: Thu, 03 Jun 2010 20:57:24 +0200
Message-ID: <9f8e6$4c07fb14$524ba3af$4345_at_cache1.tilbu1.nb.home.nl>
On 06/02/2010 04:49 PM, The Magnet wrote:
>
> We're trying to insert a value that is like 50,000 characters long
> into a CLOB column from PL/SQL. It is passed in as a parameter to a
> CLOB type.
>
> Now, from what I am reading 32k is the limit for any variable in PL/
> SQL.
>
> First, what is the best way to get around this.
> Second, if 32k is the largest, the how does one insert objects,
> photos, etc into an object column if PL/SQL can only handle 32k?
>
>
Date: Thu, 03 Jun 2010 20:57:24 +0200
Message-ID: <9f8e6$4c07fb14$524ba3af$4345_at_cache1.tilbu1.nb.home.nl>
On 06/02/2010 04:49 PM, The Magnet wrote:
>
> We're trying to insert a value that is like 50,000 characters long
> into a CLOB column from PL/SQL. It is passed in as a parameter to a
> CLOB type.
>
> Now, from what I am reading 32k is the limit for any variable in PL/
> SQL.
>
> First, what is the best way to get around this.
> Second, if 32k is the largest, the how does one insert objects,
> photos, etc into an object column if PL/SQL can only handle 32k?
>
>
32k at the time, until all is processed. Similar to eating elephants.
-- Regards, Frank van BortelReceived on Thu Jun 03 2010 - 13:57:24 CDT