Re: CLOB
From: The Magnet <art_at_unsu.com>
Date: Thu, 5 Nov 2009 10:44:55 -0800 (PST)
Message-ID: <5a3f5c1b-05ac-4b83-b4f4-b754a262bda6_at_g23g2000yqh.googlegroups.com>
On Nov 5, 10:01 am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> On Nov 4, 5:23 pm, The Magnet <a..._at_unsu.com> wrote:
>
> > This may be a dumb question, but why can't Oracle read anything
> > greater than 32767?? EvenCLOB's? You really have to loop and do
> > some crappy stuff??
>
> How are you trying to read the LOB? The sqlldr utility can read LOB's
> over 32K. Now the utl_file utility used to have a 32K record size
> limit in it. Are you using it?
>
> What full version of Oracle? Oracle capabilities for dealing with LOB
> data has evolved over the releases since 8.0 introdduced the data
> type.
>
> HTH -- Mark D Powell --
Date: Thu, 5 Nov 2009 10:44:55 -0800 (PST)
Message-ID: <5a3f5c1b-05ac-4b83-b4f4-b754a262bda6_at_g23g2000yqh.googlegroups.com>
On Nov 5, 10:01 am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> On Nov 4, 5:23 pm, The Magnet <a..._at_unsu.com> wrote:
>
> > This may be a dumb question, but why can't Oracle read anything
> > greater than 32767?? EvenCLOB's? You really have to loop and do
> > some crappy stuff??
>
> How are you trying to read the LOB? The sqlldr utility can read LOB's
> over 32K. Now the utl_file utility used to have a 32K record size
> limit in it. Are you using it?
>
> What full version of Oracle? Oracle capabilities for dealing with LOB
> data has evolved over the releases since 8.0 introdduced the data
> type.
>
> HTH -- Mark D Powell --
We are using PHP to perform the actual call to the DB. My solution was to return 2 variables, breaking the CLOB up and having PHP receive 2 output values.
Still, a dumb limitation. You'd think by this point Oracle would have fixed that. Received on Thu Nov 05 2009 - 12:44:55 CST