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: 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).