I would recommend upgrading to 7.6.x you can download it from www.quest.com
>From: "AK" <oramagic_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: ORA-03115 (TOAD question!!)
>Date: Tue, 29 Jul 2003 07:49:23 -0800
>
>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: Charu Joshi
> > INET: joshic_at_mahindrabt.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).
> >
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: AK
> INET: oramagic_at_hotmail.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).
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jay Wade
INET: fish_dba_at_hotmail.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).
Received on Tue Jul 29 2003 - 15:19:25 CDT
