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

Johannes Eggers wrote:

[Quoted] > OK.... Now I can't find anyone here that gets it to work in SqlNavigator,
> 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

I have SQL Navigator. If you send me something to test ... I'll test it for you [Quoted] tonight or tomorrow.

Daniel Morgan Received on Thu Jan 30 2003 - 23:24:42 CET