Claus Pedersen
Member³
I am trying out beta 3.
I execute the following test script in the Test Window
I enter debug mode. I step over the first SELECT line and ready to execute the second.
I try to close the window and get the dialogue: "Test window can not be closed, Script is still executing (OK/Terminate)"
I press Terminate and get the dialogue: "Save changes to Test Window - New? (Yes/No/Cancel)"
I press No and the program now hangs and will have to be terminated by Windows.
Below is the content of the debug.txt file:
I execute the following test script in the Test Window
Code:
DECLARE
my_variable dual.dummy%TYPE;
BEGIN
SELECT dummy INTO my_variable FROM dual;
SELECT dummy INTO my_variable FROM dual;
END;I try to close the window and get the dialogue: "Test window can not be closed, Script is still executing (OK/Terminate)"
I press Terminate and get the dialogue: "Save changes to Test Window - New? (Yes/No/Cancel)"
I press No and the program now hangs and will have to be terminated by Windows.
Below is the content of the debug.txt file:
Code:
PL/SQL Developer 7.0.3.1110 01.1012 - 1 user license
C:\Program Files\PLSQL Developer\plsqldev.exe
04-09-2006 10:11:59 Application started
04-09-2006 10:11:59 InitPreferences
04-09-2006 10:11:59 Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
04-09-2006 10:11:59 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
04-09-2006 10:11:59 PreferenceSet.Load OK
04-09-2006 10:11:59 Load C:\Program Files\PLSQL Developer\Preferences\CP = 0
04-09-2006 10:11:59 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\CP\default.ini
04-09-2006 10:11:59 PreferenceSet.Load OK
04-09-2006 10:11:59 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\CP\user.prefs
04-09-2006 10:11:59 PreferenceSet.Load OK
04-09-2006 10:11:59 InitPreferences end
04-09-2006 10:11:59 SortPreferenceSets
04-09-2006 10:11:59 - Default CP
04-09-2006 10:11:59 - System Default
04-09-2006 10:11:59 LoadPreferences
04-09-2006 10:11:59 LoadPreferences searching for default
04-09-2006 10:11:59 C:\Program Files\PLSQL Developer\Preferences\CP\default.ini
04-09-2006 10:11:59 LoadPreferences end
04-09-2006 10:12:00 FormCreate Logon.Execute
04-09-2006 10:12:00 TOracleSession PLSQLDevForm.Session Start Session.LogOn as dsv52_udv/dsv52_udv@thebe
04-09-2006 10:12:00 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
04-09-2006 10:12:00 TOracleQuery Query End (1 record processed)
Duration = 0
04-09-2006 10:12:00 TOracleSession PLSQLDevForm.Session End
Duration = 0,063
04-09-2006 10:12:00 LogonHistorySave start
04-09-2006 10:12:00 ChangeUserPref LogonHistory,
04-09-2006 10:12:00 ChangeUserPref DSA,
04-09-2006 10:12:00 ChangeUserPref end
04-09-2006 10:12:00 ChangeUserPref ColumnAssociations,
04-09-2006 10:12:00 ChangeUserPref end
04-09-2006 10:12:00 ChangeUserPref ImportAssociations,
04-09-2006 10:12:00 ChangeUserPref end
04-09-2006 10:12:00 ChangeUserPref BrowserFilters,
04-09-2006 10:12:00 ChangeUserPref end
04-09-2006 10:12:00 ChangeUserPref BrowserFolders,
04-09-2006 10:12:00 ChangeUserPref end
04-09-2006 10:12:00 ChangeUserPref SessionQueries,
04-09-2006 10:12:00 ChangeUserPref end
04-09-2006 10:12:00 ChangeUserPref ExternalTools,
04-09-2006 10:12:00 ChangeUserPref end
04-09-2006 10:12:00 ChangeUserPref Documents,
04-09-2006 10:12:00 ChangeUserPref end
04-09-2006 10:12:00 ChangeUserPref Reports,
04-09-2006 10:12:00 ChangeUserPref end
04-09-2006 10:12:00 LogonHistorySave end
04-09-2006 10:12:00 FormCreate Session.Connected
04-09-2006 10:12:00 FormCreate Logon.Executed -1
04-09-2006 10:12:00 FormCreate TDBNames.Make
04-09-2006 10:12:00 FormCreate SessionChanged
04-09-2006 10:12:00 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
04-09-2006 10:12:00 TOracleQuery Query End (5 records processed)
Duration = 0
04-09-2006 10:12:00 SessionChanged SetDBAViews
04-09-2006 10:12:00 SessionChanged Authorizations.Load
04-09-2006 10:12:00 TOracleQuery 634B60 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)
04-09-2006 10:12:00 TOracleQuery 634B60 End
Result = ORA-00942: table or view does not exist
Duration = 0
04-09-2006 10:12:00 SessionChanged EnableAuthorizedMenus
04-09-2006 10:12:00 TOracleSession E58750 Start Session.LogOn as dsv52_udv@thebe
04-09-2006 10:12:00 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
04-09-2006 10:12:00 TOracleQuery Query End (1 record processed)
Duration = 0
04-09-2006 10:12:00 TOracleSession E58750 End
Duration = 0,031
04-09-2006 10:12:00 SetSessionAction starts: Main session
04-09-2006 10:12:00 TOracleQuery 634A00 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')
04-09-2006 10:12:00 TOracleQuery 634CC0 Start Query.Execute
SQL = select null from dual
04-09-2006 10:12:00 TOracleQuery 634CC0 End (1 record processed)
Duration = 0
04-09-2006 10:12:00 TOracleQuery 634CC0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0
04-09-2006 10:12:00 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0,016
04-09-2006 10:12:00 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0
04-09-2006 10:12:00 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery 634CC0 End
Duration = 0,016
04-09-2006 10:12:00 SetSessionAction ends
04-09-2006 10:12:00 ExecuteConnectScript starts
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0
04-09-2006 10:12:00 ExecuteConnectScript ends
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0
04-09-2006 10:12:00 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 SessionChanged LoadRecentObjects
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0
04-09-2006 10:12:00 SessionChanged Notify children
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 SessionChanged Logoff secondary sessions
04-09-2006 10:12:00 SessionChanged SessionMode = smMulti
04-09-2006 10:12:00 TOracleQuery 634A00 End (32 records processed)
Duration = 0
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Execute
SQL = select s.synonym_name object_name, o.object_type
from sys.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')
04-09-2006 10:12:00 SessionChanged EnableChildFunctions
04-09-2006 10:12:00 Toolbar.NavDisable
04-09-2006 10:12:00 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME1
OracleHomeDir: C:\orant
Found: oci.dll
Found: ORA803.DLL
Found: ORA804.DLL
Found: ORA805.DLL
Using: C:\orant\bin\oci.dll
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0,344
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 Toolbar.NavDisable
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0,11
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0,015
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0,016
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0,016
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0,015
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:00 TOracleQuery 634A00 End (100 records processed)
Duration = 0,047
04-09-2006 10:12:00 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:01 TOracleQuery 634A00 End (100 records processed)
Duration = 0,063
04-09-2006 10:12:01 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:01 TOracleQuery 634A00 End (100 records processed)
Duration = 0,015
04-09-2006 10:12:01 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:01 TOracleQuery 634A00 End (100 records processed)
Duration = 0,016
04-09-2006 10:12:01 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:01 SortPreferenceSets
04-09-2006 10:12:01 - Default CP
04-09-2006 10:12:01 - System Default
04-09-2006 10:12:01 TOracleQuery 634A00 End (100 records processed)
Duration = 0,016
04-09-2006 10:12:01 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:01 TOracleQuery 634A00 End (100 records processed)
Duration = 0,015
04-09-2006 10:12:01 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:01 TOracleQuery 634A00 End (100 records processed)
Duration = 0,016
04-09-2006 10:12:01 TOracleQuery 634A00 Start Query.Next for up to 100 records
04-09-2006 10:12:01 TOracleQuery 634A00 End (69 records processed)
Duration = 0,172
04-09-2006 10:12:01 TOracleSession E58750 Start Session.LogOff
04-09-2006 10:12:01 TOracleSession E58750 End
Duration = 0
04-09-2006 10:12:01 Toolbar.NavDisable
04-09-2006 10:12:01 Toolbar.NavDisable
04-09-2006 10:12:01 Toolbar.NavDisable
04-09-2006 10:12:01 Toolbar.NavDisable
04-09-2006 10:12:01 WMUpdatePopups starts
04-09-2006 10:12:01 LoadDesktop starts
04-09-2006 10:12:01 LoadDesktop ends
04-09-2006 10:12:01 WMUpdatePopups ends
04-09-2006 10:12:05 Create TTestForm
04-09-2006 10:12:05 Toolbar.NavDisable
04-09-2006 10:12:05 NavigationBookmarks.EnableButtons(Rebuild)
04-09-2006 10:12:05 NavigationBookmarks: Backward=0, Forward=0
04-09-2006 10:12:58 TOracleQuery 6350E0 Start Query.Execute
SQL = select 'x' from dual
04-09-2006 10:12:58 TOracleQuery 6350E0 End (1 record processed)
Duration = 0
04-09-2006 10:13:04 SetConnected starts
04-09-2006 10:13:04 SetConnected: ForceLogoff starts
04-09-2006 10:13:04 SetConnected: ForceLogoff ends
04-09-2006 10:13:04 SetConnected: Connect starts
04-09-2006 10:13:04 TOracleSession E5AEB0 Start Session.LogOn as dsv52_udv@thebe
04-09-2006 10:13:04 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
04-09-2006 10:13:04 TOracleQuery Query End (1 record processed)
Duration = 0,015
04-09-2006 10:13:04 TOracleSession E5AEB0 End
Duration = 0,062
04-09-2006 10:13:04 SetConnected: (Dis)connect ends
04-09-2006 10:13:04 SetSessionAction starts: Test Window - New
04-09-2006 10:13:04 TOracleQuery 6366E0 Start Query.Execute
SQL = select null from dual
04-09-2006 10:13:04 TOracleQuery 6366E0 End (1 record processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery 6366E0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Test Window - New
04-09-2006 10:13:04 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
04-09-2006 10:13:04 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
04-09-2006 10:13:04 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery 6366E0 End
Duration = 0
04-09-2006 10:13:04 SetSessionAction ends
04-09-2006 10:13:04 ExecuteConnectScript starts
04-09-2006 10:13:04 ExecuteConnectScript ends
04-09-2006 10:13:04 TOracleQuery 6366E0 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
04-09-2006 10:13:04 TOracleQuery 6366E0 End (1 record processed)
Duration = 0
04-09-2006 10:13:04 InitHTPOutput starts
04-09-2006 10:13:04 TOracleQuery 6366E0 Start Query.Execute
SQL = begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
04-09-2006 10:13:04 TOracleQuery 6366E0 End
Duration = 0
04-09-2006 10:13:04 InitHTPOutput finished
04-09-2006 10:13:04 EnableOutput starts
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.EnableOutputQuery Start Query.Execute
SQL = begin
if :enable = 0 then
sys.dbms_output.disable;
else
sys.dbms_output.enable(:size);
end if;
end;
:ENABLE = 1
:SIZE = 1000000
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
04-09-2006 10:13:04 EnableOutput done
04-09-2006 10:13:04 InitializeTargetSession starts
04-09-2006 10:13:04 TOracleQuery Debugger.InitializeTargetQuery Start Query.Execute
SQL = begin
--sys.dbms_session.reset_package;
sys.dbms_debug.probe_version(major => :major, minor => :minor);
:debug_session_id := sys.dbms_debug.initialize;
sys.dbms_debug.debug_on;
end;
:DEBUG_SESSION_ID = Null
:MAJOR = Null
:MINOR = Null
04-09-2006 10:13:04 TOracleQuery Debugger.InitializeTargetQuery End
Duration = 0,016
04-09-2006 10:13:04 TOracleSession Debugger.Session Start Session.LogOn as dsv52_udv@thebe
04-09-2006 10:13:04 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
04-09-2006 10:13:04 TOracleQuery Query End (1 record processed)
Duration = 0
04-09-2006 10:13:04 TOracleSession Debugger.Session End
Duration = 0,047
04-09-2006 10:13:04 SetSessionAction starts: Debug Test Window - New
04-09-2006 10:13:04 TOracleQuery 6366E0 Start Query.Execute
SQL = select null from dual
04-09-2006 10:13:04 TOracleQuery 6366E0 End (1 record processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery 6366E0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Debug Test Window - New
04-09-2006 10:13:04 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
04-09-2006 10:13:04 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
04-09-2006 10:13:04 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery 6366E0 End
Duration = 0,015
04-09-2006 10:13:04 SetSessionAction ends
04-09-2006 10:13:04 ExecuteConnectScript starts
04-09-2006 10:13:04 ExecuteConnectScript ends
04-09-2006 10:13:04 InitializeTargetSession ends
04-09-2006 10:13:04 InitStatistics starts
04-09-2006 10:13:04 TStatistics.Init starts
04-09-2006 10:13:04 InitStatNames starts
04-09-2006 10:13:04 select name from v$statname order by statistic#
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select name from v$statname order by statistic#
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,016
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
04-09-2006 10:13:04 InitStatNames ends
04-09-2006 10:13:04 StatQuery.Describe starts
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.StatQuery Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.StatQuery End
Duration = 0
04-09-2006 10:13:04 StatQuery.Describe ends
04-09-2006 10:13:04 TStatistics.Init ends
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 53
04-09-2006 10:13:04 TOracleQuery PLSQLDevForm.StatQuery End (251 records processed)
Duration = 0
04-09-2006 10:13:04 InitStatistics ends
04-09-2006 10:13:04 NavigationBookmarks.EnableButtons(Rebuild)
04-09-2006 10:13:04 NavigationBookmarks: Backward=0, Forward=0
04-09-2006 10:13:04 Debugger.Attach starts
04-09-2006 10:13:04 TSQLThread SQLThread.Execute
04-09-2006 10:13:04 TOracleQuery Debugger.AttachQuery Start Query.Execute
SQL = declare
runtime_info sys.dbms_debug.runtime_info;
begin
sys.dbms_debug.default_timeout := :default_timeout;
runtime_info.program.namespace := null;
runtime_info.program.name := null;
runtime_info.program.owner := null;
runtime_info.program.dblink := null;
runtime_info.line# := null;
runtime_info.terminated := null;
runtime_info.breakpoint := null;
runtime_info.stackdepth := null;
runtime_info.interpreterdepth := null;
runtime_info.reason := null;
sys.dbms_debug.attach_session(debug_session_id => :debug_session_id);
:sync_result := sys.dbms_debug.synchronize(run_info => runtime_info,
info_requested => sys.dbms_debug.info_getStackDepth +
sys.dbms_debug.info_getLineInfo +
sys.dbms_debug.info_getBreakpoint);
:program_namespace := runtime_info.program.namespace;
:program_name := runtime_info.program.name;
:program_owner := runtime_info.program.owner;
:program_dblink := runtime_info.program.dblink;
:line# := runtime_info.line#;
:terminated := runtime_info.terminated;
:breakpoint := runtime_info.breakpoint;
:stackdepth := runtime_info.stackdepth;
:interpreterdepth := runtime_info.interpreterdepth;
:reason := runtime_info.reason;
sys.dbms_debug.default_timeout := 3600;
end;
:DEBUG_SESSION_ID = 003591D50001
:PROGRAM_NAMESPACE = Null
:PROGRAM_NAME = Null
:PROGRAM_OWNER = Null
:PROGRAM_DBLINK = Null
:LINE# = Null
:TERMINATED = Null
:BREAKPOINT = Null
:STACKDEPTH = Null
:INTERPRETERDEPTH = Null
:REASON = Null
:SYNC_RESULT = Null
:DEFAULT_TIMEOUT = 10
04-09-2006 10:13:04 TOracleQuery TestForm.TestQuery Start Query.Execute
SQL = DECLARE
my_variable dual.dummy%TYPE;
BEGIN
SELECT dummy INTO my_variable FROM dual;
SELECT dummy INTO my_variable FROM dual;
END;
04-09-2006 10:13:04 TOracleQuery Debugger.AttachQuery End
Duration = 0
04-09-2006 10:13:04 Debugger.Attach ends with 0
04-09-2006 10:13:04 NavigationBookmarks.EnableButtons(Rebuild)
04-09-2006 10:13:04 NavigationBookmarks: Backward=0, Forward=0
04-09-2006 10:13:04 Continue starts(12,0) .[] - L: T:0 B: S: I:1 R:2
04-09-2006 10:13:04 TOracleQuery Debugger.ContinueQuery Start Query.Execute
SQL = declare
runtime_info sys.dbms_debug.runtime_info;
sync_result integer;
begin
sys.dbms_debug.default_timeout := :default_timeout;
runtime_info.program.namespace := :program_namespace;
runtime_info.program.name := :program_name;
runtime_info.program.owner := :program_owner;
runtime_info.program.dblink := :program_dblink;
runtime_info.line# := :line#;
runtime_info.terminated := :terminated;
runtime_info.breakpoint := :breakpoint;
runtime_info.stackdepth := :stackdepth;
runtime_info.interpreterdepth := :interpreterdepth;
runtime_info.reason := :reason;
if :do_sync = 1 then
sync_result := sys.dbms_debug.synchronize(run_info => runtime_info,
info_requested => sys.dbms_debug.info_getStackDepth +
sys.dbms_debug.info_getLineInfo +
sys.dbms_debug.info_getBreakpoint);
end if;
:cont_result := sys.dbms_debug.continue(run_info => runtime_info,
breakflags => :breakflags,
info_requested => sys.dbms_debug.info_getStackDepth +
sys.dbms_debug.info_getLineInfo +
sys.dbms_debug.info_getBreakpoint);
:program_namespace := runtime_info.program.namespace;
:program_name := runtime_info.program.name;
:program_owner := runtime_info.program.owner;
:program_dblink := runtime_info.program.dblink;
:line# := runtime_info.line#;
:terminated := runtime_info.terminated;
:breakpoint := runtime_info.breakpoint;
:stackdepth := runtime_info.stackdepth;
:interpreterdepth := runtime_info.interpreterdepth;
:reason := runtime_info.reason;
sys.dbms_debug.default_timeout := 3600;
end;
:PROGRAM_NAMESPACE = Null
:PROGRAM_NAME =
:PROGRAM_OWNER =
:PROGRAM_DBLINK =
:LINE# = Null
:TERMINATED = 0
:BREAKPOINT = Null
:STACKDEPTH = Null
:INTERPRETERDEPTH = 1
:REASON = 2
:BREAKFLAGS = 12
:DEFAULT_TIMEOUT = 3600
:CONT_RESULT = Null
:DO_SYNC = 0
04-09-2006 10:13:04 TOracleQuery Debugger.ContinueQuery End
Duration = 0,016
04-09-2006 10:13:04 Continue ends with 0 .[] - L:4 T: B:0 S:1 I: R:6
04-09-2006 10:13:04 NavigationBookmarks.EnableButtons(Rebuild)
04-09-2006 10:13:04 NavigationBookmarks: Backward=0, Forward=0
04-09-2006 10:13:04 AddDBSource starts
04-09-2006 10:13:04 AddDBSource finished
04-09-2006 10:13:04 GetCallStack starts
04-09-2006 10:13:04 TOracleQuery Debugger.PrintBacktraceTableQuery Start Query.Execute
SQL = declare
-- Probe 2.1
backtrace sys.dbms_debug.backtrace_table;
program_info sys.dbms_debug.program_info;
i integer;
j integer;
begin
sys.dbms_debug.print_backtrace(listing => :listing);
begin
sys.dbms_debug.print_backtrace(backtrace => backtrace);
exception
when others then backtrace.delete;
end;
:names := '';
:namespaces := '';
:owners := '';
:lines := '';
i := backtrace.first;
j := 0;
while (i is not null) and (j < 100) loop
program_info := backtrace(i);
:names := :names || program_info.name || chr(10);
:namespaces := :namespaces || to_char(program_info.namespace) || chr(10);
:owners := :owners || program_info.owner || chr(10);
:lines := :lines || to_char(program_info.line#) || chr(10);
i := backtrace.next(i);
j := j + 1;
end loop;
end;
:LISTING = Null
:NAMES = Null
:OWNERS = Null
:LINES = Null
:NAMESPACES = Null
04-09-2006 10:13:04 TOracleQuery Debugger.PrintBacktraceTableQuery End
Duration = 0,015
04-09-2006 10:13:04 GetCallStack ends
04-09-2006 10:13:05 NavigationBookmarks.EnableButtons(Rebuild)
04-09-2006 10:13:05 NavigationBookmarks: Backward=0, Forward=0
04-09-2006 10:13:05 Continue starts(32,0) .[] - L:4 T: B:0 S:1 I: R:6
04-09-2006 10:13:05 TOracleQuery Debugger.ContinueQuery Start Query.Execute
SQL = declare
runtime_info sys.dbms_debug.runtime_info;
sync_result integer;
begin
sys.dbms_debug.default_timeout := :default_timeout;
runtime_info.program.namespace := :program_namespace;
runtime_info.program.name := :program_name;
runtime_info.program.owner := :program_owner;
runtime_info.program.dblink := :program_dblink;
runtime_info.line# := :line#;
runtime_info.terminated := :terminated;
runtime_info.breakpoint := :breakpoint;
runtime_info.stackdepth := :stackdepth;
runtime_info.interpreterdepth := :interpreterdepth;
runtime_info.reason := :reason;
if :do_sync = 1 then
sync_result := sys.dbms_debug.synchronize(run_info => runtime_info,
info_requested => sys.dbms_debug.info_getStackDepth +
sys.dbms_debug.info_getLineInfo +
sys.dbms_debug.info_getBreakpoint);
end if;
:cont_result := sys.dbms_debug.continue(run_info => runtime_info,
breakflags => :breakflags,
info_requested => sys.dbms_debug.info_getStackDepth +
sys.dbms_debug.info_getLineInfo +
sys.dbms_debug.info_getBreakpoint);
:program_namespace := runtime_info.program.namespace;
:program_name := runtime_info.program.name;
:program_owner := runtime_info.program.owner;
:program_dblink := runtime_info.program.dblink;
:line# := runtime_info.line#;
:terminated := runtime_info.terminated;
:breakpoint := runtime_info.breakpoint;
:stackdepth := runtime_info.stackdepth;
:interpreterdepth := runtime_info.interpreterdepth;
:reason := runtime_info.reason;
sys.dbms_debug.default_timeout := 3600;
end;
:PROGRAM_NAMESPACE = Null
:PROGRAM_NAME =
:PROGRAM_OWNER =
:PROGRAM_DBLINK =
:LINE# = 4
:TERMINATED = Null
:BREAKPOINT = 0
:STACKDEPTH = 1
:INTERPRETERDEPTH = Null
:REASON = 6
:BREAKFLAGS = 32
:DEFAULT_TIMEOUT = 3600
:CONT_RESULT = 0
:DO_SYNC = 0
04-09-2006 10:13:05 TOracleQuery Debugger.ContinueQuery End
Duration = 0,015
04-09-2006 10:13:05 Continue ends with 0 .[] - L:5 T: B:0 S:1 I: R:9
04-09-2006 10:13:05 NavigationBookmarks.EnableButtons(Rebuild)
04-09-2006 10:13:05 NavigationBookmarks: Backward=0, Forward=0
04-09-2006 10:13:05 AddDBSource starts
04-09-2006 10:13:05 AddDBSource finished
04-09-2006 10:13:05 GetCallStack starts
04-09-2006 10:13:05 TOracleQuery Debugger.PrintBacktraceTableQuery Start Query.Execute
SQL = declare
-- Probe 2.1
backtrace sys.dbms_debug.backtrace_table;
program_info sys.dbms_debug.program_info;
i integer;
j integer;
begin
sys.dbms_debug.print_backtrace(listing => :listing);
begin
sys.dbms_debug.print_backtrace(backtrace => backtrace);
exception
when others then backtrace.delete;
end;
:names := '';
:namespaces := '';
:owners := '';
:lines := '';
i := backtrace.first;
j := 0;
while (i is not null) and (j < 100) loop
program_info := backtrace(i);
:names := :names || program_info.name || chr(10);
:namespaces := :namespaces || to_char(program_info.namespace) || chr(10);
:owners := :owners || program_info.owner || chr(10);
:lines := :lines || to_char(program_info.line#) || chr(10);
i := backtrace.next(i);
j := j + 1;
end loop;
end;
:LISTING = <source not available>
:NAMES =
:OWNERS =
:LINES = 4
:NAMESPACES = 0
04-09-2006 10:13:05 TOracleQuery Debugger.PrintBacktraceTableQuery End
Duration = 0
04-09-2006 10:13:05 GetCallStack ends
04-09-2006 10:13:09 Aborting thread
04-09-2006 10:13:09 NavigationBookmarks.EnableButtons(Rebuild)
04-09-2006 10:13:09 NavigationBookmarks: Backward=0, Forward=0
04-09-2006 10:13:09 NavigationBookmarks.EnableButtons(Rebuild)
04-09-2006 10:13:09 NavigationBookmarks: Backward=0, Forward=0
04-09-2006 10:13:18 Destroying TTestForm
04-09-2006 10:13:18 Toolbar.NavDisable
04-09-2006 10:13:18 Destroyed TTestForm
