Re: CLOB > 32k
From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Wed, 02 Jun 2010 15:07:46 GMT
Message-ID: <6tuNn.5749$z%6.2794_at_edtnps83>
"The Magnet" <art_at_unsu.com> wrote in message news:f40c0053-0fef-473a-a206-f9319a55669c_at_q8g2000vbm.googlegroups.com...
>
> 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: Wed, 02 Jun 2010 15:07:46 GMT
Message-ID: <6tuNn.5749$z%6.2794_at_edtnps83>
"The Magnet" <art_at_unsu.com> wrote in message news:f40c0053-0fef-473a-a206-f9319a55669c_at_q8g2000vbm.googlegroups.com...
>
> 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?
Check out the dbms_lob package.
-- Terry DykstraReceived on Wed Jun 02 2010 - 10:07:46 CDT