I can't read korean & chinese in program window.

woojong

Member
PARAMETER VALUE
1 NLS_NCHAR_CHARACTERSET AL16UTF16
2 NLS_CHARACTERSET UTF8

We use oracle 9.1.7 with pl/sql 7.1.

I am testing 7.1 in order to upgrade from 5.1 these days.

Problem is, when I open a package in program window, I can't read any characters in korean & chinese. This has never happened in 5.1 before.
for example,
...
* CREATED BY : ???곗?
* DESCRIPTION : ?깃린??梨???procedures
...
GROUP BY decode(erc.shouce_uom, '?ф??, 0,

I have looked up in this forum without success.

Here is the debug trace file.

PL/SQL Developer 7.1.1.1339
C:\Program Files\PLSQL Developer\PLSQLDev.exe

2007-06-18 오후 5:01:24 Application started
2007-06-18 오후 5:01:24 InitPreferences
2007-06-18 오후 5:01:24 Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
2007-06-18 오후 5:01:24 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
2007-06-18 오후 5:01:24 PreferenceSet.Load OK
2007-06-18 오후 5:01:24 Load C:\Program Files\PLSQL Developer\Preferences\WOOJONGHONG = 0
2007-06-18 오후 5:01:24 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\WOOJONGHONG\default.ini
2007-06-18 오후 5:01:24 PreferenceSet.Load OK
2007-06-18 오후 5:01:24 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\WOOJONGHONG\user.prefs
2007-06-18 오후 5:01:24 PreferenceSet.Load OK
2007-06-18 오후 5:01:24 InitPreferences end
2007-06-18 오후 5:01:24 SortPreferenceSets
2007-06-18 오후 5:01:24 - Default WOOJONGHONG
2007-06-18 오후 5:01:24 - System Default
2007-06-18 오후 5:01:24 LoadPreferences
2007-06-18 오후 5:01:24 LoadPreferences searching for default
2007-06-18 오후 5:01:24 C:\Program Files\PLSQL Developer\Preferences\WOOJONGHONG\default.ini
2007-06-18 오후 5:01:24 LoadPreferences NewPref := nil
2007-06-18 오후 5:01:24 LoadPreferences
2007-06-18 오후 5:01:24 LoadPreferences Reading preferences
2007-06-18 오후 5:01:24 LoadPreferences ReadPosition
2007-06-18 오후 5:01:24 LoadPreferences ToolsBrowserItemClick(nil)
2007-06-18 오후 5:01:24 LoadPreferences CreateBrowserFilters...
2007-06-18 오후 5:01:24 LoadPreferences Files
2007-06-18 오후 5:01:24 LoadPreferences Logon
2007-06-18 오후 5:01:24 LoadPreferences Buttons
2007-06-18 오후 5:01:24 LoadPreferences Printer
2007-06-18 오후 5:01:24 LoadPreferences BrowserFolders
2007-06-18 오후 5:01:24 LoadPreferences
2007-06-18 오후 5:01:24 LoadPreferences end
2007-06-18 오후 5:01:24 FormCreate Logon.Execute
2007-06-18 오후 5:01:26 LogonHistorySave start
2007-06-18 오후 5:01:26 ChangeUserPref LogonHistory,
2007-06-18 오후 5:01:26 ChangeUserPref DSA,
2007-06-18 오후 5:01:26 ChangeUserPref end
2007-06-18 오후 5:01:26 ChangeUserPref ColumnAssociations,
2007-06-18 오후 5:01:26 ChangeUserPref end
2007-06-18 오후 5:01:26 ChangeUserPref ImportAssociations,
2007-06-18 오후 5:01:26 ChangeUserPref end
2007-06-18 오후 5:01:26 ChangeUserPref BrowserFilters,
2007-06-18 오후 5:01:26 ChangeUserPref end
2007-06-18 오후 5:01:26 ChangeUserPref BrowserFolders,
2007-06-18 오후 5:01:26 ChangeUserPref end
2007-06-18 오후 5:01:26 ChangeUserPref SessionQueries,
2007-06-18 오후 5:01:26 ChangeUserPref end
2007-06-18 오후 5:01:26 ChangeUserPref ExternalTools,
2007-06-18 오후 5:01:26 ChangeUserPref end
2007-06-18 오후 5:01:26 ChangeUserPref Documents,
2007-06-18 오후 5:01:26 ChangeUserPref end
2007-06-18 오후 5:01:26 ChangeUserPref Reports,
2007-06-18 오후 5:01:26 ChangeUserPref end
2007-06-18 오후 5:01:26 LogonHistorySave end
2007-06-18 오후 5:01:26 FormCreate Session.Connected
2007-06-18 오후 5:01:26 FormCreate Logon.Executed -1
2007-06-18 오후 5:01:26 FormCreate TDBNames.Make
2007-06-18 오후 5:01:26 FormCreate SessionChanged
2007-06-18 오후 5:01:26 SessionChanged SetDBAViews
2007-06-18 오후 5:01:26 SessionChanged Authorizations.Load
2007-06-18 오후 5:01:26 SessionChanged EnableAuthorizedMenus
2007-06-18 오후 5:01:26 SetSessionAction starts: Main session
2007-06-18 오후 5:01:26 SetSessionAction ends
2007-06-18 오후 5:01:26 ExecuteConnectScript starts
2007-06-18 오후 5:01:26 ExecuteConnectScript ends
2007-06-18 오후 5:01:26 SessionChanged LoadRecentObjects
2007-06-18 오후 5:01:26 SessionChanged Notify children
2007-06-18 오후 5:01:26 SessionChanged Logoff secondary sessions
2007-06-18 오후 5:01:26 SessionChanged SessionMode = smMulti
2007-06-18 오후 5:01:26 SessionChanged EnableChildFunctions
2007-06-18 오후 5:01:27 Toolbar.NavDisable
2007-06-18 오후 5:01:27 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: C:\orant
Found: oci.dll
Found: ORA73.DLL
Found: ORA803.DLL
Found: ORA804.DLL
Found: ora805.dll
Using: C:\orant\bin\oci.dll
2007-06-18 오후 5:01:27 Toolbar.NavDisable
2007-06-18 오후 5:01:27 SortPreferenceSets
2007-06-18 오후 5:01:27 - Default WOOJONGHONG
2007-06-18 오후 5:01:27 - System Default
2007-06-18 오후 5:01:27 Toolbar.NavDisable
2007-06-18 오후 5:01:27 Toolbar.NavDisable
2007-06-18 오후 5:01:27 Toolbar.NavDisable
2007-06-18 오후 5:01:27 WMUpdatePopups starts
2007-06-18 오후 5:01:27 LoadDesktop starts
2007-06-18 오후 5:01:27 LoadDesktop ends
2007-06-18 오후 5:01:27 WMUpdatePopups ends
2007-06-18 오후 5:01:32 Create TSQLForm
2007-06-18 오후 5:01:32 SQLForm
2007-06-18 오후 5:01:32 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:01:32 NavigationBookmarks: Backward=0, Forward=0
2007-06-18 오후 5:01:48 AddPlugInPopups Start 0
2007-06-18 오후 5:01:48 AddPlugInPopups End
2007-06-18 오후 5:01:48 AddPlugInPopups Start 0
2007-06-18 오후 5:01:48 AddPlugInPopups End
2007-06-18 오후 5:01:48 AddPlugInPopups Start 0
2007-06-18 오후 5:01:48 AddPlugInPopups End
2007-06-18 오후 5:01:50 Create TProcEditForm
2007-06-18 오후 5:01:50 AddNavigationBookmark starts
2007-06-18 오후 5:01:50 AddNavigationBookmark GNV00001
2007-06-18 오후 5:01:50 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:01:50 NavigationBookmarks: Backward=1, Forward=0
2007-06-18 오후 5:01:50 AddNavigationBookmark ends
2007-06-18 오후 5:01:50 ProcEditForm.GetTabNames
2007-06-18 오후 5:01:50 + ebom_register_pkg
2007-06-18 오후 5:01:50 ProcEditForm.GetTabNames done
2007-06-18 오후 5:01:51 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:01:51 NavigationBookmarks: Backward=1, Forward=0
2007-06-18 오후 5:01:51 UpdateContents(Clear)
2007-06-18 오후 5:01:51 Source = CREATE OR REPLACE PACKAGE ebom_register_pkg AUTHID CURRENT_USER AS
2007-06-18 오후 5:01:51 UpdatingContents: Thread Started
2007-06-18 오후 5:01:51 ContentsThread: Execute
2007-06-18 오후 5:01:51 ContentsThread: Analyze
2007-06-18 오후 5:01:51 ContentsThread: Valid
2007-06-18 오후 5:01:51 ContentsThread: Suspend started
2007-06-18 오후 5:01:51 ProcEditForm.GetTabNames
2007-06-18 오후 5:01:51 + ebom_register_pkg
2007-06-18 오후 5:01:51 + ebom_register_pkg
2007-06-18 오후 5:01:51 ProcEditForm.GetTabNames done
2007-06-18 오후 5:01:51 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:01:51 NavigationBookmarks: Backward=1, Forward=0
2007-06-18 오후 5:01:51 UpdateContents(Clear)
2007-06-18 오후 5:01:51 Source = CREATE OR REPLACE PACKAGE BODY ebom_register_pkg AS
2007-06-18 오후 5:01:51 UpdatingContents: Thread Started
2007-06-18 오후 5:01:51 ContentsThread: Resume
2007-06-18 오후 5:01:51 ContentsThread: Analyze
2007-06-18 오후 5:01:52 ContentsThread: Valid
2007-06-18 오후 5:01:52 ContentsThread: Suspend started
2007-06-18 오후 5:01:52 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:01:52 NavigationBookmarks: Backward=1, Forward=0
2007-06-18 오후 5:01:52 ContentsUpdated
2007-06-18 오후 5:01:52 ContentsUpdated: Valid
2007-06-18 오후 5:01:52 ContentsUpdated: Refresh Code Contents
2007-06-18 오후 5:01:52 ContentsUpdated
2007-06-18 오후 5:01:52 ContentsUpdated: Valid
2007-06-18 오후 5:01:52 ContentsUpdated: Refresh Code Contents
2007-06-18 오후 5:02:07 Create TSQLForm
2007-06-18 오후 5:02:07 SQLForm
2007-06-18 오후 5:02:07 AddNavigationBookmark starts
2007-06-18 오후 5:02:07 AddNavigationBookmark GNV00002
2007-06-18 오후 5:02:07 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:02:07 NavigationBookmarks: Backward=2, Forward=0
2007-06-18 오후 5:02:07 AddNavigationBookmark ends
2007-06-18 오후 5:02:07 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:02:07 NavigationBookmarks: Backward=2, Forward=0
2007-06-18 오후 5:02:09 SQLForm Initializing...
2007-06-18 오후 5:02:09 SetConnected starts
2007-06-18 오후 5:02:09 SetConnected: Connect starts
2007-06-18 오후 5:02:09 SetConnected: (Dis)connect ends
2007-06-18 오후 5:02:09 SetSessionAction starts: SQL Window - New
2007-06-18 오후 5:02:09 SetSessionAction ends
2007-06-18 오후 5:02:09 ExecuteConnectScript starts
2007-06-18 오후 5:02:09 ExecuteConnectScript ends
2007-06-18 오후 5:02:10 EnableOutput starts
2007-06-18 오후 5:02:10 EnableOutput done
2007-06-18 오후 5:02:10 InitStatistics starts
2007-06-18 오후 5:02:10 TStatistics.Init starts
2007-06-18 오후 5:02:10 InitStatNames starts
2007-06-18 오후 5:02:10 select name from v$statname order by statistic#
2007-06-18 오후 5:02:10 InitStatNames ends
2007-06-18 오후 5:02:10 StatQuery.Describe starts
2007-06-18 오후 5:02:10 StatQuery.Describe ends
2007-06-18 오후 5:02:10 TStatistics.Init ends
2007-06-18 오후 5:02:10 InitStatistics ends
2007-06-18 오후 5:02:10 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:02:10 NavigationBookmarks: Backward=2, Forward=0
2007-06-18 오후 5:02:10 SQLForm Executing...
2007-06-18 오후 5:02:10 SQLForm Executing...
2007-06-18 오후 5:02:10 TSQLThread SQLThread.Execute
2007-06-18 오후 5:02:10 TSQLThread SQLThread Postmessage
2007-06-18 오후 5:02:10 TSQLForm.ThreadFinished
2007-06-18 오후 5:02:10 TSQLThread SQLThread Suspend
2007-06-18 오후 5:02:10 TSQLForm.ThreadFinished: SQLThread.Suspended
2007-06-18 오후 5:02:11 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:02:11 NavigationBookmarks: Backward=2, Forward=0
2007-06-18 오후 5:02:11 SQLForm ORA-00933: SQL command not properly ended
2007-06-18 오후 5:02:15 SQLForm Initializing...
2007-06-18 오후 5:02:15 SetConnected starts
2007-06-18 오후 5:02:15 Already connected: check connection
2007-06-18 오후 5:02:15 Using existing connection
2007-06-18 오후 5:02:15 EnableOutput starts
2007-06-18 오후 5:02:15 EnableOutput done
2007-06-18 오후 5:02:15 InitStatistics starts
2007-06-18 오후 5:02:15 InitStatistics ends
2007-06-18 오후 5:02:15 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:02:15 NavigationBookmarks: Backward=2, Forward=0
2007-06-18 오후 5:02:15 SQLForm Executing...
2007-06-18 오후 5:02:15 SQLForm Executing...
2007-06-18 오후 5:02:15 TSQLThread SQLThread Suspend ended
2007-06-18 오후 5:02:15 TSQLThread SQLThread Postmessage
2007-06-18 오후 5:02:15 TSQLThread SQLThread Suspend
2007-06-18 오후 5:02:15 TSQLForm.ThreadFinished
2007-06-18 오후 5:02:15 TSQLForm.ThreadFinished: SQLThread.Suspended
2007-06-18 오후 5:02:15 SQLForm 2 rows selected in 0.031 seconds
2007-06-18 오후 5:02:15 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:02:15 NavigationBookmarks: Backward=2, Forward=0
2007-06-18 오후 5:02:15 SQLForm 2 rows selected in 0.031 seconds
2007-06-18 오후 5:04:19 SQLForm parameter, varchar2(30), mandatory, Parameter name
2007-06-18 오후 5:04:22 SQLForm parameter, varchar2(30), mandatory, Parameter name
2007-06-18 오후 5:07:13 AddNavigationBookmark starts
2007-06-18 오후 5:07:13 AddNavigationBookmark GNV00003
2007-06-18 오후 5:07:13 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:07:13 NavigationBookmarks: Backward=3, Forward=0
2007-06-18 오후 5:07:13 AddNavigationBookmark ends
2007-06-18 오후 5:07:13 NavigationBookmarks.EnableButtons(Rebuild)
2007-06-18 오후 5:07:13 NavigationBookmarks: Backward=3, Forward=0
 
What happens if you go to Tools > Preferences > Oracle / Options and disable the "Unicode enabled" option?
 
I see that you are using Oracle Net 8.0.5. Can you upgrade to 9.0 or later and verify if that helps?

If you already have a more recent Oracle Client installation, you can select it through Tools > Preferences > Oracle / Connection (Oracle Home list).
 
Back
Top