It sounds like you have a problem with your 10g installation,
that error message you list indicates a directory listed in your client path
isn’t correct.
From:
toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of SHIVANAND
BHARTI
Sent: Monday, January 12, 2009 11:53 AM
To: toad@yahoogroups.com
Subject: RE: [toad] RE: TOAD ERROR "Datatype is not
supported".
Hi
Jeff,
These
are the Oracle Client which I have on my machine;

For
the first time when I connect to any DB (8i,10g) with my Oracle 10g client
I get following ORA-12705 error.

So
I first connect to another database using Oracle 8 client and then I connect to
any DB with Oracle 10g Client.

I
believe there is some setting issue which gives me ORA-12705 error when I log
in any DB with my Oracle 10g Client.
Can
this be an issue ?
By
the way , in addition to my previous issue do you have any idea about this
issue.
TAR,
Shiva.
From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]
On Behalf Of Jeff Smith
Sent: Monday, January 12, 2009 11:37 AM
To: toad@yahoogroups.com
Subject: [toad] RE: TOAD ERROR "Datatype is not supported".
Your assumption may not be correct…it
runs fine in my 10gR2 server/client copy of 9.7.2 Toad.
I’m betting the problem lies with your
Oracle client – what version of that are you using?
From:
toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of SHIVANAND
BHARTI
Sent: Monday, January 12, 2009 11:32 AM
To: toad@yahoogroups.com
Subject: [toad] TOAD ERROR "Datatype is not supported".
Hi All,
When
I run commands involving BITAND I get TOAD ERROR "Datatype is not
supported".
select BITAND(1,2) from dual;
I am using
Oracle 8i DB and have following Data Types enabled in my TOAD ( 9.0.1.8).
How can I
resolve this ?
I assume
BITAND applies to Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g !!!

Thanks and Regards,
Shiva.
************************************************************ NOTE:
This e-mail message contains PRIVILEGED and CONFIDENTIAL information and is
intended only for the use of the specific individual or individuals to which it
is addressed. If you are not an intended recipient of this e-mail, you are
hereby notified that any unauthorized use, dissemination or copying of this
e-mail or the information contained herein or attached hereto is strictly
prohibited. If you receive this e-mail in error, notify the person named above
by reply e-mail and please delete it. Thank you.