Re: CLOB
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 5 Nov 2009 08:01:21 -0800 (PST)
Message-ID: <86b7da9a-314f-435f-aa77-f56deaf29655_at_s31g2000yqs.googlegroups.com>
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?? Even CLOB's? You really have to loop and do
> some crappy stuff??
Date: Thu, 5 Nov 2009 08:01:21 -0800 (PST)
Message-ID: <86b7da9a-314f-435f-aa77-f56deaf29655_at_s31g2000yqs.googlegroups.com>
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?? Even CLOB'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 -- Received on Thu Nov 05 2009 - 10:01:21 CST