Prev: xaingmei chen bangs Bally Bags
Next: How to sum for last hour and last 24 hours without union all?
From: The Magnet on 2 Jun 2010 10:49

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?


From: Terry Dykstra on 2 Jun 2010 11:07
"The Magnet" <art(a)unsu.com> wrote in message
news:f40c0053-0fef-473a-a206-f9319a55669c(a)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 Dykstra


From: The Magnet on 2 Jun 2010 13:11
On Jun 2, 10:07 am, "Terry Dykstra" <tddyks...(a)forestoil.ca> wrote:
> "The Magnet" <a...(a)unsu.com> wrote in message
>
> news:f40c0053-0fef-473a-a206-f9319a55669c(a)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 Dykstra

Ok, well, however our PHP guys did it, the defined it as an object on
their end and it comes in as a CLOB and inserts just fine.

The next thing is that we open a REF cursor and the PHP reads the
record set of data, with the CLOB being part of it. The cursor is a
dynamic cursor built within the PL/SQL and then PHP reads the record
set.

But I am having issues getting the CLOB out and processed within the
REF cursor.

Any tricks while I search for an answer?

From: Frank van Bortel on 3 Jun 2010 14:57
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 Bortel
 | 
Pages: 1
Prev: xaingmei chen bangs Bally Bags
Next: How to sum for last hour and last 24 hours without union all?