Re: Help: SELECTing clob-columns in SQL Navigator gives ORA-24813: cannot send or receive an unsupported LOB

[Quoted] OK.... Now I can't find anyone here that gets it to work in SqlNavigator, [Quoted] but it does work fine in SQL+

Confused

"SoulSurvivor" <markyg_7_at_yahoo.co.uk> wrote in message news:8d9c6fd.0301300748.5b6e9c4a_at_posting.google.com...
> Versions between the client and the server for the original posters
> scenario does matter, confirmed on Metalink. If the client version
> does not support blobs but the server does, there will be problems.
>
> M
>
> DA Morgan <damorgan_at_exesolutions.com> wrote in message
news:<3E38098E.C696AD30_at_exesolutions.com>...
> > SoulSurvivor wrote:
> >
> > > I think you have to make sure that the same version of Oracle is
> > > running on the client and the server. Failing that if the client
> > > version of Oracle is different to the server, the client version of
> > > Oracle has to support clobs.
> > >
> > > M
> > >
> > > "Johannes Eggers" <jeggers_at_tetrix.com> wrote in message
news:<b13t34$visev$1_at_ID-178358.news.dfncis.de>...
> > > > When I run a query such as:
> > > >
> > > > SELECT * FROM foo
> > > >
> > > > I get a
> > > > ORA-24813: cannot send or receive an unsupported LOB
> > > > if there is a CLOB column in the table (and if there are rows in the
table).
> > > >
> > > > Other users don't have the problem, but they seem to run the same
version of
> > > > SQL Navigator and Oracle Client... Is there some config. parameter
I need
> > > > to tweak ?
> > > >
> > > > Thanks,
> > > >
> > > > Johannes
> >
> > No reason to care if the versions are the same: It is irrelevant. The
only consideration is that the
> > functionality required is supported.
> >
> > Daniel Morgan
Received on Thu Jan 30 2003 - 19:53:20 CET