[DB-SIG] Using CLOBs in Oracle 8.1.5

Neal Norwitz nnorwitz@yahoo.com
Fri, 12 May 2000 09:56:37 -0400

A colleague investigated this problem as far as I know, it appears that
the oci_.c code is using the Oracle version 7 APIs to get the data.
I think CLOBs weren't supported in version 7.  So it appears that
oci_.c needs to be upgraded (possibly a lot of work) to use the version 8
in order to make CLOBs work.

We, at least temporarily, switched to use LONGs which do work.


Andreas Jung wrote:

> On Wed, May 03, 2000 at 01:08:52PM -0400, Neal Norwitz wrote:
> > Hi!
> >
> > I am able to send CLOBs Oracle 8.1.5, but I cannot read them from
> > Oracle.
> >
> > I get the error:  ORA-24813: cannot send or receive an unsupported LOB
> > when I try to do a fetch (fetchall or fetchone).
> >
> > I am able to get the description and it shows the CLOB column as a
> > STRING of the correct size (4000).
> > This code works on all tables without a CLOB.
> Hi,
> did you get rid of the problem ? I must working on a solution
> on the same problem but with very less success :-(
> Andreas

Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.