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

[Quoted] I'd appreciate it:

[Quoted] CREATE TABLE foo (

  name                       VARCHAR2(50) NOT NULL,
  xsl_pp                     CLOB DEFAULT empty_clob()

INSERT INTO foo VALUES ('myfoofoo', 'foofoo');
INSERT INTO foo VALUES ('mybarbar', 'barbar');
INSERT INTO foo VALUES ('myfoobar', 'foobar');

Commit the inserts, then, in SQL Navigator:

SELECT * FROM foo

I get the it-sucks-so-hard ORA-24813: cannot send or receive an unsupported LOB [Quoted] I'm not an oracle guy, but doesn't the fact that the error # is greater (or [Quoted] technically lower) than -20000 imply that it's a custom error, i.e. a SQL [Quoted] Navigator issue rather than an oracle(-client library) issue ?

Johannes

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E39A62A.BE35977A_at_exesolutions.com...
> Johannes Eggers wrote:
>
> > 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
> tonight or tomorrow.
>
> Daniel Morgan
>
Received on Fri Jan 31 2003 - 00:14:04 CET