Home » Developer & Programmer » Forms » How to make TOAD connect to Oracle 9i ??
How to make TOAD connect to Oracle 9i ?? [message #80235] Wed, 28 August 2002 03:00 Go to next message
Ray
Messages: 58
Registered: January 2000
Member
Hello, after upgrade the Oracle to 9i, my TOAD 7.1 cannot connect to Oracle 9i. Ummm, actually, it can connect to 9i, but it always prompt the "ORA-01026: multiple buffers of size > 4000 in the bind list" error message. Although it can show the tablenames in the object browser, but it can not do anything further.

Please help me !!!

Thanks in advance.

Report message to a moderator

Re: How to make TOAD connect to Oracle 9i ?? [message #80241 is a reply to message #80235] Wed, 28 August 2002 14:22 Go to previous messageGo to next message
Stefan Mueller
Messages: 11
Registered: January 2002
Junior Member
Have you installed Oracle9i in UTF8 characterset? ... in which case just make sure you set your client nls_lang settings (in the registry!) to american_america.utf8 !

Report message to a moderator

Re: How to make TOAD connect to Oracle 9i ?? [message #80525 is a reply to message #80235] Tue, 08 October 2002 05:51 Go to previous messageGo to next message
Jacq
Messages: 1
Registered: October 2002
Junior Member
I have the same problem. My database is UTF8 and my NLS_LANG setting is American_America.UTF8. You do get fewer ORA-01026 errors if you connect as the table owner.

Report message to a moderator

Re: How to make TOAD connect to Oracle 9i ?? [message #80598 is a reply to message #80241] Fri, 18 October 2002 12:36 Go to previous messageGo to next message
GK
Messages: 22
Registered: January 2001
Junior Member
How does one make these registry changes?

Report message to a moderator

Re: How to make TOAD connect to Oracle 9i ?? [message #81837 is a reply to message #80235] Tue, 25 March 2003 09:32 Go to previous message
Ravi
Messages: 251
Registered: June 1998
Senior Member
The feeling here is that you don't want to set the characterset in the registry to utf8 unless your client is in fact using that characterset. You may end up corrupting your data. The best advise is to upgrade your version of TOAD to the latest available version.

Report message to a moderator

Previous Topic: Developer2000
Next Topic: Scrollbar on form
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 19 02:20:08 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.