CLOB display hangs

[peledc]

Hi,

On PL/SQL Developer, version 7.1.4.1390
When I open a SQL window, select data and click on a CLOB window to view it's contents with the "large data view" The application hangs for a long time. I waited more than 60 minutes with no progress. This happens on other Oracle DB and on other desktop pc in my place.
I have run the application with DEBUGSQL and bellow is the output:

Thanks
Alon Peled
PL/SQL Developer
Version 7.1.4.1390
Windows 2000 Professional 5.0 Build 2195 (Service Pack 4)

Physical memory : 1,023,220 kB (577,148 available)
Paging file : 2,462,088 kB (2,055,768 available)
Virtual memory : 2,097,024 kB (2,029,628 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
debugsql

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files

Plug-Ins

12/02/2008 14:31:00 Application started
12/02/2008 14:31:00 InitPreferences
12/02/2008 14:31:00 Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
12/02/2008 14:31:00 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
12/02/2008 14:31:00 PreferenceSet.Load OK
12/02/2008 14:31:00 Determine LocalPrefPath
12/02/2008 14:31:00 [1]: C:\Program Files\PLSQL Developer\Preferences
12/02/2008 14:31:00 LocalPrefPath: C:\Program Files\PLSQL Developer\Preferences\alon_pe
12/02/2008 14:31:00 Load C:\Program Files\PLSQL Developer\Preferences\alon_pe = 0
12/02/2008 14:31:00 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\alon_pe\default.ini
12/02/2008 14:31:00 PreferenceSet.Load OK
12/02/2008 14:31:00 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\alon_pe\user.prefs
12/02/2008 14:31:00 PreferenceSet.Load OK
12/02/2008 14:31:00 InitPreferences end
12/02/2008 14:31:00 SortPreferenceSets
12/02/2008 14:31:00 - Default alon_pe
12/02/2008 14:31:00 - System Default
12/02/2008 14:31:00 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
12/02/2008 14:31:00 ReadString OK
12/02/2008 14:31:00 pfReadRegistry: "C:\Program Files\PLSQL Developer\plsqldev.exe" "%1"
12/02/2008 14:31:00 LoadPreferences
12/02/2008 14:31:00 LoadPreferences searching for default
12/02/2008 14:31:00 C:\Program Files\PLSQL Developer\Preferences\alon_pe\default.ini
12/02/2008 14:31:00 LoadPreferences NewPref := nil
12/02/2008 14:31:00 LoadPreferences
12/02/2008 14:31:00 LoadPreferences Reading preferences
12/02/2008 14:31:00 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
12/02/2008 14:31:00 ReadString OK
12/02/2008 14:31:00 pfReadRegistry: "C:\Program Files\PLSQL Developer\plsqldev.exe" "%1"
12/02/2008 14:31:00 LoadPreferences ReadPosition
12/02/2008 14:31:00 LoadPreferences ToolsBrowserItemClick(nil)
12/02/2008 14:31:00 LoadPreferences CreateBrowserFilters...
12/02/2008 14:31:00 LoadPreferences Files
12/02/2008 14:31:00 LoadPreferences Logon
12/02/2008 14:31:00 LoadPreferences Buttons
12/02/2008 14:31:00 LoadPreferences Printer
12/02/2008 14:31:00 LoadPreferences BrowserFolders
12/02/2008 14:31:00 LoadPreferences
12/02/2008 14:31:00 LoadPreferences end
12/02/2008 14:31:00 MacroLibFilename: C:\Program Files\PLSQL Developer\Macro\alon_pe.lib
12/02/2008 14:31:00 FormCreate Logon.Execute
12/02/2008 14:31:02 TOracleSession PLSQLDevForm.Session Start Session.LogOn as a2c@opensys_tst
12/02/2008 14:31:04 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
12/02/2008 14:31:04 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.047
12/02/2008 14:31:04 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
12/02/2008 14:31:04 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
12/02/2008 14:31:04 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
12/02/2008 14:31:04 TOracleQuery Query End (1 record processed)
Duration = 0
12/02/2008 14:31:04 TOracleSession PLSQLDevForm.Session End
Duration = 1.406
12/02/2008 14:31:04 LogonHistorySave start
12/02/2008 14:31:04 ChangeUserPref LogonHistory,
12/02/2008 14:31:04 ChangeUserPref DSA,
12/02/2008 14:31:04 ChangeUserPref end
12/02/2008 14:31:04 ChangeUserPref ColumnAssociations,
12/02/2008 14:31:04 ChangeUserPref end
12/02/2008 14:31:04 ChangeUserPref ImportAssociations,
12/02/2008 14:31:04 ChangeUserPref end
12/02/2008 14:31:04 ChangeUserPref BrowserFilters,
12/02/2008 14:31:04 ChangeUserPref end
12/02/2008 14:31:04 ChangeUserPref BrowserFolders,
12/02/2008 14:31:04 ChangeUserPref end
12/02/2008 14:31:04 ChangeUserPref SessionQueries,
12/02/2008 14:31:04 ChangeUserPref end
12/02/2008 14:31:04 ChangeUserPref ExternalTools,
12/02/2008 14:31:04 ChangeUserPref end
12/02/2008 14:31:04 ChangeUserPref Documents,
12/02/2008 14:31:04 ChangeUserPref end
12/02/2008 14:31:04 ChangeUserPref Reports,
12/02/2008 14:31:04 ChangeUserPref end
12/02/2008 14:31:04 LogonHistorySave end
12/02/2008 14:31:04 FormCreate Session.Connected
12/02/2008 14:31:04 FormCreate Logon.Executed -1
12/02/2008 14:31:04 FormCreate TDBNames.Make
12/02/2008 14:31:04 FormCreate SessionChanged
12/02/2008 14:31:04 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
12/02/2008 14:31:04 TOracleQuery Query End (5 records processed)
Duration = 0.016
12/02/2008 14:31:04 SessionChanged SetDBAViews
12/02/2008 14:31:04 TOracleQuery $0310FDC0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
12/02/2008 14:31:04 TOracleQuery $0310FDC0 End (0 records processed)
Duration = 0
12/02/2008 14:31:04 TOracleQuery $0310FDC0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
12/02/2008 14:31:04 TOracleQuery $0310FDC0 End
Result = ORA-00942: table or view does not exist
Duration = 0.015
12/02/2008 14:31:04 SessionChanged Authorizations.Load
12/02/2008 14:31:04 TOracleQuery $0310FC60 Start Query.Execute
SQL = select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
12/02/2008 14:31:04 TOracleQuery $0310FC60 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
12/02/2008 14:31:04 SessionChanged EnableAuthorizedMenus
12/02/2008 14:31:04 TOracleSession $019AF1D0 Start Session.LogOn as a2c@opensys_tst
12/02/2008 14:31:04 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
12/02/2008 14:31:04 TOracleQuery Query End (1 record processed)
Duration = 0
12/02/2008 14:31:04 TOracleSession $019AF1D0 End
Duration = 0.156
12/02/2008 14:31:04 SetSessionAction starts: Main session
12/02/2008 14:31:04 TOracleQuery $0310FF20 Start Query.Execute
SQL = select object_name, object_type
from sys.user_objects o
where o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
12/02/2008 14:31:04 TOracleQuery $0310FDC0 Start Query.Execute
SQL = select null from dual
12/02/2008 14:31:04 TOracleQuery $0310FDC0 End (1 record processed)
Duration = 0
12/02/2008 14:31:04 TOracleQuery $0310FF20 End (100 records processed)
Duration = 0
12/02/2008 14:31:04 TOracleQuery $0310FDC0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
12/02/2008 14:31:04 TOracleQuery $0310FF20 Start Query.Next for up to 100 records
12/02/2008 14:31:04 TOracleQuery $0310FF20 End (100 records processed)
Duration = 0
12/02/2008 14:31:04 TOracleQuery $0310FF20 Start Query.Next for up to 100 records
12/02/2008 14:31:04 TOracleQuery $0310FDC0 End
Duration = 0.016
12/02/2008 14:31:04 TOracleQuery $0310FF20 End (100 records processed)
Duration = 0
12/02/2008 14:31:04 SetSessionAction ends
12/02/2008 14:31:04 TOracleQuery $0310FF20 Start Query.Next for up to 100 records
12/02/2008 14:31:04 ExecuteConnectScript starts
12/02/2008 14:31:04 ExecuteConnectScript ends
12/02/2008 14:31:04 TOracleQuery $0310FF20 End (37 records processed)
Duration = 0
12/02/2008 14:31:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
12/02/2008 14:31:04 TOracleQuery $0310FF20 Start Query.Execute
SQL = select s.synonym_name object_name, o.object_type
from all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
12/02/2008 14:31:04 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
12/02/2008 14:31:04 SessionChanged LoadRecentObjects
12/02/2008 14:31:04 SessionChanged Notify children
12/02/2008 14:31:04 SessionChanged Logoff secondary sessions
12/02/2008 14:31:04 SessionChanged SessionMode = smMulti
12/02/2008 14:31:04 SessionChanged EnableChildFunctions
12/02/2008 14:31:04 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient10g_home
OracleHomeDir: O:\ORACLE\ORA10
Found: oci.dll
Using: O:\ORACLE\ORA10\bin\oci.dll
12/02/2008 14:31:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
12/02/2008 14:31:04 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
12/02/2008 14:31:04 SortPreferenceSets
12/02/2008 14:31:04 - Default alon_pe
12/02/2008 14:31:04 - System Default
12/02/2008 14:31:04 TOracleQuery $0310FB00 Start Query.Execute
SQL = select null from all_synonyms where 1=0
12/02/2008 14:31:04 TOracleQuery $0310FB00 End (0 records processed)
Duration = 0
12/02/2008 14:31:04 TOracleQuery $0310FB00 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
12/02/2008 14:31:04 TOracleQuery $0310FB00 End
Result = ORA-00942: table or view does not exist
Duration = 0
12/02/2008 14:31:04 WMUpdatePopups starts
12/02/2008 14:31:04 GetCrashList: 1376352.cfg
12/02/2008 14:31:04 GetCrashList: 1376352.cfg
12/02/2008 14:31:04 TOracleQuery $0310FF20 End (100 records processed)
Duration = 0.297
12/02/2008 14:31:04 TOracleQuery $0310FF20 Start Query.Next for up to 100 records
12/02/2008 14:31:04 TOracleQuery $0310FF20 End (100 records processed)
Duration = 0.016
12/02/2008 14:31:04 TOracleQuery $0310FF20 Start Query.Next for up to 100 records
12/02/2008 14:31:05 TOracleQuery $0310FF20 End (100 records processed)
Duration = 0.078
12/02/2008 14:31:05 TOracleQuery $0310FF20 Start Query.Next for up to 100 records
12/02/2008 14:31:05 TOracleQuery $0310FF20 End (100 records processed)
Duration = 0.031
12/02/2008 14:31:05 TOracleQuery $0310FF20 Start Query.Next for up to 100 records
12/02/2008 14:31:05 TOracleQuery $0310FF20 End (100 records processed)
Duration = 0.062
12/02/2008 14:31:05 TOracleQuery $0310FF20 Start Query.Next for up to 100 records
12/02/2008 14:31:05 TOracleQuery $0310FF20 End (100 records processed)
Duration = 0.063
12/02/2008 14:31:05 TOracleQuery $0310FF20 Start Query.Next for up to 100 records
12/02/2008 14:31:05 TOracleQuery $0310FF20 End (100 records processed)
Duration = 0.015
12/02/2008 14:31:05 TOracleQuery $0310FF20 Start Query.Next for up to 100 records
12/02/2008 14:31:05 TOracleQuery $0310FF20 End (100 records processed)
Duration = 0.016
12/02/2008 14:31:05 TOracleQuery $0310FF20 Start Query.Next for up to 100 records
12/02/2008 14:31:05 TOracleQuery $0310FF20 End (100 records processed)
Duration = 0.047
12/02/2008 14:31:05 TOracleQuery $0310FF20 Start Query.Next for up to 100 records
12/02/2008 14:31:05 TOracleQuery $0310FF20 End (25 records processed)
Duration = 0.156
12/02/2008 14:31:05 TOracleSession $019AF1D0 Start Session.LogOff
12/02/2008 14:31:05 TOracleSession $019AF1D0 End
Duration = 0
12/02/2008 14:31:06 Create TSQLForm Start
12/02/2008 14:31:06 Create TSQLForm Inherited
12/02/2008 14:31:06 TSQLForm.FormCreate Start
12/02/2008 14:31:06 SQLForm
12/02/2008 14:31:07 TSQLForm.FormCreate Finished
12/02/2008 14:31:07 Create TSQLForm SetupMainFont
12/02/2008 14:31:07 Create TSQLForm Activate
12/02/2008 14:31:07 Create TSQLForm Activate done
12/02/2008 14:31:07 Create TSQLForm UpdateWindowList
12/02/2008 14:31:07 Create TSQLForm Positioning
12/02/2008 14:31:07 Create TSQLForm Finished
12/02/2008 14:31:07 FileAge: C:\DOCUME~1\alon_pe\LOCALS~1\Temp\PLS-Recovery\1376352.001 = 14:24:22
12/02/2008 14:31:07 SQLForm
12/02/2008 14:31:07 SQLForm
12/02/2008 14:31:07 SQLForm Recovery file loaded
12/02/2008 14:31:07 NavigationBookmarks.EnableButtons(Rebuild)
12/02/2008 14:31:07 NavigationBookmarks: Backward=0, Forward=0
12/02/2008 14:31:07 WMUpdatePopups ends
12/02/2008 14:31:09 SQLForm Initializing...
12/02/2008 14:31:09 SetConnected starts
12/02/2008 14:31:09 SetConnected: Connect starts
12/02/2008 14:31:09 TOracleSession $019B2650 Start Session.LogOn as a2c@opensys_tst
12/02/2008 14:31:09 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
12/02/2008 14:31:09 TOracleQuery Query End (1 record processed)
Duration = 0
12/02/2008 14:31:09 TOracleSession $019B2650 End
Duration = 0.125
12/02/2008 14:31:09 SetConnected: (Dis)connect ends
12/02/2008 14:31:09 SetSessionAction starts: SQL Window - select A.Request_Id,A.Id,A.Timesmtp,EXTRACT((A.message),'/Message/OrchestrationName/text()').get ...
12/02/2008 14:31:09 TOracleQuery $0310F580 Start Query.Execute
SQL = select null from dual
12/02/2008 14:31:09 TOracleQuery $0310F580 End (1 record processed)
Duration = 0
12/02/2008 14:31:09 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
12/02/2008 14:31:09 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
12/02/2008 14:31:09 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
12/02/2008 14:31:09 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
12/02/2008 14:31:09 TOracleQuery $0310F580 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - select A.Request_Id,A.Id,A.Timesmtp,EXTRACT((A.message),'/Message/OrchestrationName/text()').get ...
12/02/2008 14:31:09 TOracleQuery $0310F580 End
Duration = 0
12/02/2008 14:31:09 SetSessionAction ends
12/02/2008 14:31:09 ExecuteConnectScript starts
12/02/2008 14:31:09 ExecuteConnectScript ends
12/02/2008 14:31:09 TOracleQuery $0310F580 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
12/02/2008 14:31:09 TOracleQuery $0310F580 End (1 record processed)
Duration = 0.016
12/02/2008 14:31:09 EnableOutput starts
12/02/2008 14:31:09 TOracleQuery PLSQLDevForm.EnableOutputQuery Start Query.Execute
SQL = begin
if :enable = 0 then
sys.dbms_output.disable;
else
sys.dbms_output.enablesize);
end if;
end;
:ENABLE = 1
:SIZE = 10000
12/02/2008 14:31:09 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
12/02/2008 14:31:09 EnableOutput done
12/02/2008 14:31:09 InitStatistics starts
12/02/2008 14:31:09 TStatistics.Init starts
12/02/2008 14:31:09 InitStatNames starts
12/02/2008 14:31:09 select name from v$statname order by statistic#
12/02/2008 14:31:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select name from v$statname order by statistic#
12/02/2008 14:31:09 TOracleQuery PLSQLDevForm.DynamicQuery End
Result = ORA-00942: table or view does not exist
Duration = 0
12/02/2008 14:31:09 TStatistics.Init ends
12/02/2008 14:31:09 InitStatistics ends
12/02/2008 14:31:09 NavigationBookmarks.EnableButtons(Rebuild)
12/02/2008 14:31:09 NavigationBookmarks: Backward=0, Forward=0
12/02/2008 14:31:09 SQLForm Executing...
12/02/2008 14:31:09 SQLForm Executing...
12/02/2008 14:31:09 TSQLThread SQLThread.Execute
12/02/2008 14:31:09 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
12/02/2008 14:31:09 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:09 TOracleQuery $0310F6E0 Start Query.Execute
SQL = select A.Request_Id,A.Id,A.Timesmtp,EXTRACT((A.message),'/Message/OrchestrationName/text()').getstringval() Orch_name,A.Message,rowid from A2C_BTS_MESSAGETRACING A
12/02/2008 14:31:10 TOracleQuery $0310F6E0 End (100 records processed)
Duration = 1.078
12/02/2008 14:31:10 TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM A2C_BTS_MESSAGETRACING
12/02/2008 14:31:10 TOracleQuery SQLForm.TestQuery End
Duration = 0.016
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0.016
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(31032)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(31123)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0.016
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0.016
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(31157)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0.015
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(30823)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(31292)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0.015
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(31383)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(31417)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0.015
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(31083)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0.016
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(17040)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(17131)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0.016
12/02/2008 14:31:10 SQLForm Executing... (10)
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(17165)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(16914)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(17298)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(17389)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(17423)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(17131)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(47748)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(47839)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(47873)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = declare
doa_object sys.xmltype;
xmldata clob;
begin
doa_object := :doa_object;
xmldata := doa_object.getclobval();
sys.dbms_lob.trimxmldata, 0);
sys.dbms_lob.appendxmldata, xmldata);
end;
OA_OBJECT = (Object)
:XMLDATA = (CLOB)
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Length
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 TLOBLocator Start LOB.Read(47482)
12/02/2008 14:31:10 TLOBLocator End
Duration = 0
12/02/2008 14:31:10 SQLForm Executing... (20)
12/02/2008 14:31:10 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
12/02/2008 14:31:10 TOracleQuery Query End
Duration = 0
12/02/2008 14:31:10 TSQLThread SQLThread Postmessage
12/02/2008 14:31:10 TSQLForm.ThreadFinished
12/02/2008 14:31:10 TSQLThread SQLThread Suspend
12/02/2008 14:31:11 TSQLForm.ThreadFinished: SQLThread.Suspended
12/02/2008 14:31:11 SQLForm 20 rows selected in 1.578 seconds (more...)
12/02/2008 14:31:11 NavigationBookmarks.EnableButtons(Rebuild)
12/02/2008 14:31:11 NavigationBookmarks: Backward=0, Forward=0
12/02/2008 14:31:11 TOracleQuery $0310F580 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
12/02/2008 14:31:11 TOracleQuery $0310F580 End
Duration = 0
12/02/2008 14:31:11 SQLForm 20 rows selected in 1.578 seconds (more...)
12/02/2008 14:31:13 TOracleQuery $0310F580 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
12/02/2008 14:31:13 TOracleQuery $0310F580 End (1 record processed)
Duration = 0
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ResolveSymbolQuery Start Query.Execute
SQL = declare

t_owner varchar2(30);
t_name varchar2(30);

procedure check_mview is
dummy integer;
begin
if bject_type = 'TABLE' then
select /*+rule*/ 1 into dummy
from sys.all_objects
where owner = bject_owner
and object_name = bject_name
and object_type = 'MATERIALIZED VIEW'
and rownum = 1;
bject_type := 'MATERIALIZED VIEW';
end if;
exception
when others then null;
end;

begin
:sub_object := null;
if :deep != 0 then
begin
if art2 is null then
select /*+rule*/ constraint_type, owner, constraint_name
into bject_type, bject_owner, bject_name
from sys.all_constraints c
where c.constraint_name = art1 and c.owner = :cur_schema
and rownum = 1;
else
select /*+rule*/ constraint_type, owner, constraint_name, art3
into bject_type, bject_owner, bject_name, :sub_object
from sys.all_constraints c
where c.constraint_name = art2 and c.owner = art1
and rownum = 1;
end if;
if bject_type = 'P' then bject_type := 'PRIMARY KEY'; end if;
if bject_type = 'U' then bject_type := 'UNIQUE KEY'; end if;
if bject_type = 'R' then bject_type := 'FOREIGN KEY'; end if;
if bject_type = 'C' then bject_type := 'CHECK CONSTRAINT'; end if;
return;
exception
when no_data_found then null;
end;
end if;
:sub_object := art2;
if part2 is null) or part1 != :cur_schema) then
begin
select /*+rule*/ object_type, :cur_schema, art1
into bject_type, bject_owner, bject_name
from sys.all_objects
where owner = :cur_schema
and object_name = art1
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
if bject_type = 'SYNONYM' then
select /*+rule*/ s.table_owner, s.table_name
into t_owner, t_name
from all_synonyms s
where s.synonym_name = art1
and s.owner = :cur_schema
and rownum = 1;
select /*+rule*/ o.object_type, o.owner, o.object_name
into bject_type, bject_owner, bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
end if;
:sub_object := art2;
if art3 is not null then
:sub_object := :sub_object || '.' || art3;
end if;
check_mview;
return;
exception
when no_data_found then null;
end;
end if;
begin
select /*+rule*/ s.table_owner, s.table_name
into t_owner, t_name
from all_synonyms s
where s.synonym_name = art1
and s.owner = 'PUBLIC'
and rownum = 1;
select /*+rule*/ o.object_type, o.owner, o.object_name
into bject_type, bject_owner, bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
:sub_object := art3;
begin
select /*+rule*/ o.object_type, o.owner, o.object_name
into bject_type, bject_owner, bject_name
from sys.all_objects o
where o.owner = art1
and o.object_name = art2
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
begin
if art2 is null and art3 is null
then
select /*+rule*/ 'USER', null, art1
into bject_type, bject_owner, bject_name
from sys.all_users u
where u.username = art1
and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
begin
if art2 is null and art3 is null and :deep != 0
then
select /*+rule*/ 'ROLE', null, art1
into bject_type, bject_owner, bject_name
from sys.session_roles r
where r.role = art1
and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
bject_owner := null;
bject_type := null;
bject_name := null;
:sub_object := null;
end;
ART1 = A2C_BTS_MESSAGETRACING
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
ART2 =
:SUB_OBJECT = Null
ART3 =
EEP = 0
:CUR_SCHEMA = A2C
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ResolveSymbolQuery End
Duration = 0.015
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Execute
SQL = select /*+rule*/ col.*, com.Comments
from sys.all_tab_columns col,
sys.all_col_comments com
where col.owner = 'A2C'
and col.table_name = 'A2C_BTS_MESSAGETRACING'
and com.Owner (+) = 'A2C'
and com.Table_Name (+) = 'A2C_BTS_MESSAGETRACING'
and com.Column_Name (+) = col.Column_Name
order by col.column_id
:TABLE_NAME = A2C_BTS_MESSAGETRACING
:OWNER = A2C
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
12/02/2008 14:31:13 TOracleQuery PLSQLDevForm.ColumnQuery End (0 records processed)
Duration = 0
12/02/2008 14:31:13 SQLForm message, sys.xmltype, optional
12/02/2008 14:31:13 ShowColumnEditor a2c_bts_messagetracing.message
12/02/2008 14:31:13 LargeDataEditor: CreateParser
12/02/2008 14:31:13 LargeDataEditor: GetExportDir
12/02/2008 14:31:13 LargeDataEditor: SetXMLEditorSizes
12/02/2008 14:31:13 LargeDataEditor: LoadPosition
12/02/2008 14:31:13 LargeDataEditor: LoadXMLSplitters
12/02/2008 14:31:13 LargeDataEditor: SetupMainFont
12/02/2008 14:31:13 LargeDataEditor: Set HTML CharSet
12/02/2008 14:31:13 LargeDataEditor: ImageControl
12/02/2008 14:31:13 LargeDataEditor: Initialize XML Editor
12/02/2008 14:31:13 LargeDataEditor: Get MSXMLDOM
12/02/2008 14:31:13 DataEditor XML: "Msxml2.DOMDocument"
12/02/2008 14:31:13 ShowColumnEditor LoadFromStream
12/02/2008 14:31:13 ShowColumnEditor SelectSheets
12/02/2008 14:31:13 ShowColumnEditor DataToForm
12/02/2008 14:31:13 ShowColumnEditor ShowModal

 

[Marco van der Linden]

In 'Tools/Preferences/Oracle/Options' do you have 'Unicode enabled' checked? If so, try unchecking it. It solved some of the problems I had with LOBs.

 

[peledc]

Thanks for the reply,
I tried it but it did not help.
This used to work in previous release.
We had to upgrade due to using Oracle client 10.2.0.2

 

[Marco Kalter]

I see that the CLOB is only 47482 bytes long, so that can't be the problem. Does this only happen with CLOB's, or also with BLOB's and VARCHAR2's?

 

[peledc]

Hi,

We don't use BLOB.
Varchar2 works fine.
Also, some CLOBs work fine as well.
I looked inside the CLOB. its an XML file and it works fine on the previous release.
I did not see any special characters init as well.
Would sending you the CLOB help you?
If so, please supply an email address.

Thanks for the help
Alon Peled

 

[Marco Kalter]

Okay, maybe there is something with the XML contents. Can you send me the exact XML contents as an e-mail attachment?

 

[peledc]

Hi Marco,

I have emailed a DMP file with a single table contaiing one row.
Please tell me if you can reproducde the bug.

Thanks
Alon Peled

 

[peledc]

Hi,

I send a new one.

Regards
Alon Peled

 

[Marco Kalter]

Thanks, I will check it out.