Hi,ORA-24365: error in character conversion

[jangjangjang]

Hi,
We changed our oracle database character set from WE8ISO8859P1 to UTF8 and when we run explain plan, we get the above error message. I created a new table with 1 column with no data in it and it still gave that error.

my version is 8.0.0.1480

and ideas why?

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[jangjangjang]

Hi, I dont have the ROAMING folder and i dont see any debug.txt getting created.

 

[Worker]

Try C:\Documents and Settings\\Application Data\PLSQL Developer\debug.txt

 

[jangjangjang]

There is still no DEBUG.txt file getting created. I only have PLSRecall.dat in that folder

this is my shortcut
"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

 

[Marco Kalter]

Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[jangjangjang]

Hi, I emailed you my Support Info details