RE: ORA-03115 (TOAD question!!)

7.6 is BETA. 7.5.2 is the current release. New betas appear frequently. Also, this version is not free. It's listed at just under $800 US. The freeware version is v6.x, which has the LOB bug, among a host of others.

Rich

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

> -----Original Message-----
> From: Jay Wade [mailto:fish_dba_at_hotmail.com]
> Sent: Tuesday, July 29, 2003 3:19 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: ORA-03115 (TOAD question!!)
>
>
> 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: 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).