Can PLSQL dev be used with UTF8?

[smict]

DB: Oracle92, NLS_LANG=AMERICAN_AMERICA.UTF8
Local: PLSQL developer 5.0.0.474, NLS_LANG=simplified chinese_china.zhs16gbk

I can connect with database as usual,but when I view the PLSQl code, there is the error : ORA-01460.

can PLSQL dev be used with charset UTF8?

[This message has been edited by smict (edited 25 June 2003).]

 

[Marco Kalter]

PL/SQL Developer can be used with UTF8, but for Oracle9i you will have to download and install the 5.0.3 patch release to fix this problem (or 5.1.2 if you are entitled).

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

 

[rdaudt]

We are randomly getting the ORA-01460 error when using PL/SQL developer with our UTF8 databases. They are 8.1.7 databases and we are already using PL/SQL Developer 5.1.2.682.

Any clue?

Roque Daudt

Originally posted by mkalter:
PL/SQL Developer can be used with UTF8, but for Oracle9i you will have to download and install the 5.0.3 patch release to fix this problem (or 5.1.2 if you are entitled).

 

[rdaudt]

More on that: it looks that the problem appears if we switch the database connection in the middle of a PL/SQL Developer work session (using the tools Log on/log off in the Session menu).

Roque Daudt

 

[Marco Kalter]

That is odd. We'll look into this. Do both databases use UTF8, or only the first, or only the second?

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

 

[rdaudt]

We have 14 database instances, only 2 of them with UTF8. The problem has only been seen with the UTF8 databases.

Roque Daudt

 

[Lachlan]

Has this issue been rectified, or is there a workaround? We use

NLS_LANG=american.utf8

as our standard database, and after a disconnect/reconnect, any operation which involves the structure of a table (eg desc

) will return an ORA-01460.

Currently using 5.1.3.704

 

[Marco Kalter]

This should be fixed in the current 6.0.3 version.