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

Johannes Eggers wrote:

> I'd appreciate it:
>
> 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
>
> I'm not an oracle guy, but doesn't the fact that the error # is greater (or
> technically lower) than -20000 imply that it's a custom error, i.e. a SQL
> 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
> >

NAME XSL_PP

[Quoted] myfoofoo (CLOB)
mybarbar (CLOB)
myfoobar (CLOB)

With SQL Navigator version 3.1e1

A more recent version might handle it differently ... but definitely not ORA-##### error of any kind.

Daniel Morgan Received on Fri Jan 31 2003 - 08:11:42 CET