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

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E3A21AE.52014767_at_exesolutions.com...
> 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
> >
[snip thread]
>
> NAME XSL_PP
> 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
>
Seems like it's time for an upgrade as someone suggested. I'm on 3.1d1 :-( Received on Fri Jan 31 2003 - 13:48:40 CET