toad : Message: 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.

Expand Messages

Author

Sort by Date

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

SHIVANAND BHARTI
shiva_de_novo

Jan 12, 2009
4:33 pm

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

Jeff Smith
toaddev

Jan 12, 2009
4:36 pm

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

SHIVANAND BHARTI
shiva_de_novo

Jan 12, 2009
4:54 pm

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

Jeff Smith
toaddev

Jan 12, 2009
4:59 pm

I think I have answer to my first issue. BITAND is not supported in Oracle 8i. It is strange because I saw lot of documets on net which says it does !!!!!!!! ...

SHIVANAND BHARTI
shiva_de_novo

Jan 12, 2009
5:06 pm

Key item to note about Toad and Oracle homes - you cannot have different connections using different homes within the same Toad execution. Only one Oracle home...

Bert Scalzo
bert.scalzo

Jan 12, 2009
7:38 pm

The option screen below refers only to the data types you see in the drop-down in the create/alter table window, it does not have anything to do with the error...

John Dorlon
jdorlon3

Jan 12, 2009
4:42 pm

There's the age old question....can you run it in SQL*Plus? ________________________________ From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf...

Gregory Liss
glissquest

Jan 12, 2009
4:47 pm

Yahoo! Groups Tips

Did you know...

Messages

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages