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

[Quoted] 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 - 16:48:08 CET