Help!!!It cann't work for Ora-01460 error.

[Hyacinth]

My OS: Win2K with service pack3
Oracle version: Oracle9i 9.2.0.2.0
Oracle Client: Oracle 9.2.0.1.0
PL/SQL Developer: 5.1.0.662
With PL/SQL Developer,I can enter Sql and run it,it's normal.When I try to browse the tables info.It show me a error dialog with ora-01460 error.
What's wrong? How can I do?Please help me!
Thank you!

 

[Marco Kalter]

I have no immediate clues. We'll look into this.

------------------
Marco Kalter
Allround Automations

 

[Hyacinth]

Has anybody met the same question?I try to change preferences but no use.

 

[patch]

I've had the same problems, especially when the database has been disconnected, or when I reconnect without restarting PL/SQL Developer.
Marco: We had this problem when Ora9iR2 was just released. You fixed the problem (probably partially) in version 5.0.3. Back then you figured it had something to do with the characterset settings for both the client and the database. Don't know if this helps.

Regards,
Patrick

------------------
Check out: http://www.oracledeveloper.nl

 

[Marco Kalter]

The 9iR2 multibyte character set issue was fixed in 5.0.3, and this fix is also present in 5.1. It does seem like a similar problem, but we have not yet been able to reproduce or isolate this.

------------------
Marco Kalter
Allround Automations

 

[Hyacinth]

Oh,I had forget to tell you that my OS is the Simple Chinese version.Can it bring on that problem?
btw,Whenever I can not browse any information with the PLSQL browser.

 

[dasFlugzeug]

Hi, I suggest the Allround Automations' Administrators send you the Query used by PL/SQL Developer when browsing tables. So, you try to run this query and see if problem occurs again. In this case you could see where is the problem (to_char, to_date...)

 

[Hyacinth]

Now I had installed oracle9i 9.2.0.1.0 on my personal computer.PL/SQL Developer work very well.Maybe the different Oracle character set bring on that error.I'll have another test to proof this.

 

[Hyacinth]

All ok.When I change the character set of the client to the DB server's.PL/SQL Developer does work very well.
Thank you for your help!

 

[Marco Kalter]

What was the client and server character set that caused it to fail?

------------------
Marco Kalter
Allround Automations

 

[Hyacinth]

At the beginning:
the client-side character set:SIMPLIFIED CHINESE_CHINA.ZHS16GBK
the server-side character set:AMERICAN.ZHS32GB18030

PL/SQL developer didn't work.

After I changed the client-side character set to AMERICAN.ZHS32GB18030. All ok.

In addition,I am sorry for my poor English.May you understand me!

[This message has been edited by Hyacinth (edited 25 March 2003).]

[This message has been edited by Hyacinth (edited 25 March 2003).]

 

[Marco Kalter]

I understand, thanks!

------------------
Marco Kalter
Allround Automations