RE: ORA-03115 (TOAD question!!)

It's a TOAD issue. It's fixed in one of the v7.x versions. The current supported version is 7.5.

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: AK [mailto:oramagic_at_hotmail.com]
> Sent: Tuesday, July 29, 2003 10:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: ORA-03115 (TOAD question!!)
>
>
> Not sure but this might have something to do with charset (if toad can
> handle clob??? ) . what is db charset ? is it utf8 .
>
> -ak
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, July 29, 2003 8:19 AM
>
>
> > Hi,
> >
> > I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server
> > and Oracle 7.3.4 client on my NT4 machine. When I connect to
> > remote/local databases through TOAD 6.5 (which supports LOBs) and
> > try to fetch a CLOB value I get the 'ORA-03115: Unsupported
> > network datatype or representation'.
> >
> > I think that this error is due to the limitation of CLOBs in
> > SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the
> > default home to ORA_8i_HOME(which has Net8) using the 'Home
> > Selector' utility. Also, TOAD is reading the TNSNames.Ora file
> > from this home, so should be using Net8 rather than SQL*Net. I
> > have Googled and searched Metalink, but got no clearcut reply. Can
> > you please suggest any way to rectify it?
> >
> > Thanks & regards,
> > Charu.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).