RE: ORA-03115 (TOAD question!!)

You may find it easier to just run the "Oracle Home Selector" that appears in the Startup->Programs->Oracle Installation Products menu.

It has the benefit of also modifying the PATH variable.

Jared

On Thu, 2003-07-31 at 07:54, Charu Joshi wrote:
> RE: ORA-03115 (TOAD question!!)Hi,
>
> It worked!! As suggested by Raj, I browsed the TOAD help on SQL*Net
> installation and found out this piece of information:
>
> **
> When Oracle connects, it will look in ALL_HOMES for the "LAST_HOME" value,
> which in this case is zero "0". It appends zero to "HOME" to produce
> "HOME0", then it looks in HKLM\Software\ORACLE\HOME0 for the ORACLE_HOME
> value.
> **
>
> I modified the LAST_HOME key to point to the 8i HOME and restarted TOAD and
> was able to query CLOBs successfully.
>
> Thanks a lot!!
>
> Best wishes,
> Charu
> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of
> Jamadagni, Rajendra
> Sent: Tuesday, July 29, 2003 8:21 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ORA-03115 (TOAD question!!)
>
>
> It is a TOAD question .... you need to read the sqlnet setup section from
> help file. It is pretty detailed and will help you resolve the problem.
>
> Raj
> --------------------------------------------------------------------------
> ------
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
>
>
> -----Original Message-----
> From: Charu Joshi [mailto:joshic_at_mahindrabt.com]
> Sent: Tuesday, July 29, 2003 11:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-03115 (TOAD question!!)
>
>
>
> 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: Jared Still
  INET: jkstill_at_cybcon.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).