V7 bug

Mikol

Member
Hi,

Since I use version 7, test window freeze application. I have to kill PL/SQL Dev process and restart.

What do I do :
- open PL/SQL dev,
- open Test window,
- paste my sql code which replace default test code, I select all with Ctrl-A and press Ctrl-V. My SQL code is :
SELECT *
FROM AID.DOSSIER D
WHERE D.DATENREG >= '09/12/2005'
AND D.DATENREG < '10/12/2005'
AND D.CODART = :CODART
- scan variable,
- set CODART variable to 27,
- execute query with keyboard
=> PL/SQL dev freeze.
 
Works fine for me. 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.
 
Hi,

I forget to say that freeze is only when after executing query I press Ctrl-H in variable value cell. If I'm using mouse, it works fine.

Thanks.

Here is debug.txt :

Code:
PL/SQL Developer 7.0.0.1050  02.25102 - 10 user license
C:\Program Files\PLSQL Developer\plsqldev.exe

13/02/2006 09:40:33  Application started
13/02/2006 09:40:33  InitPreferences
13/02/2006 09:40:33  Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
13/02/2006 09:40:33  PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
13/02/2006 09:40:33  PreferenceSet.Load OK
13/02/2006 09:40:33  PreferenceSet.Save
13/02/2006 09:40:33  PreferenceSet filename = C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
13/02/2006 09:40:33  PreferenceSet.Save end
13/02/2006 09:40:33  Load C:\Documents and Settings\lilacoste\Application Data\PLSQL Developer\Preferences\lilacoste = 0
13/02/2006 09:40:33  PreferenceSet.Load C:\Documents and Settings\lilacoste\Application Data\PLSQL Developer\Preferences\lilacoste\Default.ini
13/02/2006 09:40:33  PreferenceSet.Load OK
13/02/2006 09:40:33  PreferenceSet.Save
13/02/2006 09:40:33  PreferenceSet filename = C:\Documents and Settings\lilacoste\Application Data\PLSQL Developer\Preferences\lilacoste\Default.ini
13/02/2006 09:40:33  PreferenceSet.Save end
13/02/2006 09:40:33  PreferenceSet.Load C:\Documents and Settings\lilacoste\Application Data\PLSQL Developer\Preferences\lilacoste\user.prefs
13/02/2006 09:40:33  PreferenceSet.Load OK
13/02/2006 09:40:33  InitPreferences end
13/02/2006 09:40:33  SortPreferenceSets
13/02/2006 09:40:33   - lilacoste
13/02/2006 09:40:33   - System Default
13/02/2006 09:40:34  LoadPreferences
13/02/2006 09:40:34  LoadPreferences searching for default
13/02/2006 09:40:34    C:\Documents and Settings\lilacoste\Application Data\PLSQL Developer\Preferences\lilacoste\Default.ini
13/02/2006 09:40:34  LoadPreferences end
13/02/2006 09:40:34  FormCreate Logon.Execute
13/02/2006 09:40:34  TOracleSession PLSQLDevForm.Session Start Session.LogOn as aid/a@aides.world
13/02/2006 09:40:35  TOracleQuery Query Start Query.Execute
                     SQL = select to_char(userenv('SESSIONID')) from dual
13/02/2006 09:40:35  TOracleQuery Query End  (1 record processed)
                     Duration = 0.015
13/02/2006 09:40:35  TOracleSession PLSQLDevForm.Session End
                     Duration = 0.484
13/02/2006 09:40:35  FormCreate Session.Connected
13/02/2006 09:40:35  FormCreate Logon.Executed -1
13/02/2006 09:40:35  FormCreate TDBNames.Make
13/02/2006 09:40:35  FormCreate SessionChanged
13/02/2006 09:40:35  TOracleQuery Query Start Query.Execute
                     SQL = select * from v$version
13/02/2006 09:40:35  TOracleQuery Query End  (5 records processed)
                     Duration = 0
13/02/2006 09:40:35  SessionChanged SetDBAViews
13/02/2006 09:40:35  SessionChanged Authorizations.Load
13/02/2006 09:40:35  TOracleQuery 499620 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)
13/02/2006 09:40:35  TOracleQuery 499620 End
                     Result = ORA-00942: Table ou vue inexistante
                     Duration = 0
13/02/2006 09:40:35  SessionChanged EnableAuthorizedMenus
13/02/2006 09:40:35  TOracleSession 94CF10 Start Session.LogOn as aid@aides.world
13/02/2006 09:40:35  TOracleQuery Query Start Query.Execute
                     SQL = select to_char(userenv('SESSIONID')) from dual
13/02/2006 09:40:35  TOracleQuery Query End  (1 record processed)
                     Duration = 0.015
13/02/2006 09:40:35  TOracleSession 94CF10 End
                     Duration = 0.109
13/02/2006 09:40:35  SetSessionAction starts: Main session
13/02/2006 09:40:35  TOracleQuery 4998A0 Start Query.Execute
                     SQL = select null from dual
13/02/2006 09:40:35  TOracleQuery 4994E0 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')
13/02/2006 09:40:35  TOracleQuery 4998A0 End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:35  TOracleQuery 4998A0 Start Query.Execute
                     SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
                     :ACTION = Main session
13/02/2006 09:40:35  TOracleQuery BytesPerCharacterQuery Start Query.Execute
                     SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3,  length(chr(20000)) l2 from dual
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (100 records processed)
                     Duration = 0
13/02/2006 09:40:35  TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35  TOracleQuery BytesPerCharacterQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:35  TOracleQuery 4998A0 End
                     Duration = 0
13/02/2006 09:40:35  SetSessionAction ends
13/02/2006 09:40:35  ExecuteConnectScript starts
13/02/2006 09:40:35  ExecuteConnectScript ends
13/02/2006 09:40:35  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
                     SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (100 records processed)
                     Duration = 0.016
13/02/2006 09:40:35  TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35  TOracleQuery PLSQLDevForm.DynamicQuery End  (0 records processed)
                     Duration = 0
13/02/2006 09:40:35  SessionChanged LoadRecentObjects
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (37 records processed)
                     Duration = 0.015
13/02/2006 09:40:35  TOracleQuery 4994E0 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')
13/02/2006 09:40:35  SessionChanged Notify children
13/02/2006 09:40:35  SessionChanged Logoff secondary sessions
13/02/2006 09:40:35  SessionChanged SessionMode = smDual
13/02/2006 09:40:35  SessionChanged EnableChildFunctions
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (100 records processed)
                     Duration = 0.016
13/02/2006 09:40:35  TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (100 records processed)
                     Duration = 0.016
13/02/2006 09:40:35  TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (100 records processed)
                     Duration = 0.031
13/02/2006 09:40:35  TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35  SessionChanged
                     OracleHomeKey: SOFTWARE\ORACLE\HOME0
                     OracleHomeDir: C:\oracle\ora81
                     Found: oci.dll
                     Using: C:\oracle\ora81\bin\oci.dll
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (100 records processed)
                     Duration = 0.016
13/02/2006 09:40:35  TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (100 records processed)
                     Duration = 0.016
13/02/2006 09:40:35  TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (100 records processed)
                     Duration = 0.015
13/02/2006 09:40:35  TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (100 records processed)
                     Duration = 0.016
13/02/2006 09:40:35  TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (100 records processed)
                     Duration = 0.016
13/02/2006 09:40:35  TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (100 records processed)
                     Duration = 0.016
13/02/2006 09:40:35  TOracleQuery 4994E0 Start Query.Next for up to 100 records
13/02/2006 09:40:35  TOracleQuery 4994E0 End  (44 records processed)
                     Duration = 0.016
13/02/2006 09:40:35  TOracleSession 94CF10 Start Session.LogOff
13/02/2006 09:40:35  TOracleSession 94CF10 End
                     Duration = 0
13/02/2006 09:40:35  SortPreferenceSets
13/02/2006 09:40:35   - lilacoste
13/02/2006 09:40:35   - System Default
13/02/2006 09:40:38  Create TTestForm
13/02/2006 09:40:44  SetConnected starts
13/02/2006 09:40:44  SetConnected: Connect starts
13/02/2006 09:40:44  TOracleSession PLSQLDevForm.94D1B0 Start Session.LogOn as aid@aides.world
13/02/2006 09:40:45  TOracleQuery Query Start Query.Execute
                     SQL = select to_char(userenv('SESSIONID')) from dual
13/02/2006 09:40:45  TOracleQuery Query End  (1 record processed)
                     Duration = 0.016
13/02/2006 09:40:45  TOracleSession PLSQLDevForm.94D1B0 End
                     Duration = 0.109
13/02/2006 09:40:45  SetConnected: (Dis)connect ends
13/02/2006 09:40:45  SetSessionAction starts: Secondary session
13/02/2006 09:40:45  TOracleQuery 499C60 Start Query.Execute
                     SQL = select null from dual
13/02/2006 09:40:45  TOracleQuery 499C60 End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery 499C60 Start Query.Execute
                     SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
                     :ACTION = Secondary session
13/02/2006 09:40:45  TOracleQuery BytesPerCharacterQuery Start Query.Execute
                     SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3,  length(chr(20000)) l2 from dual
13/02/2006 09:40:45  TOracleQuery BytesPerCharacterQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery 499C60 End
                     Duration = 0
13/02/2006 09:40:45  SetSessionAction ends
13/02/2006 09:40:45  ExecuteConnectScript starts
13/02/2006 09:40:45  ExecuteConnectScript ends
13/02/2006 09:40:45  TOracleQuery 499C60 Start Query.Execute
                     SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
13/02/2006 09:40:45  TOracleQuery 499C60 End  (1 record processed)
                     Duration = 0.016
13/02/2006 09:40:45  InitHTPOutput starts
13/02/2006 09:40:45  TOracleQuery 499C60 Start Query.Execute
                     SQL = begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
13/02/2006 09:40:45  TOracleQuery 499C60 End
                     Duration = 0
13/02/2006 09:40:45  InitHTPOutput finished
13/02/2006 09:40:45  EnableOutput starts
13/02/2006 09:40:45  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 = 10000
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.EnableOutputQuery End
                     Duration = 0
13/02/2006 09:40:45  EnableOutput done
13/02/2006 09:40:45  InitStatistics starts
13/02/2006 09:40:45  TStatistics.Init starts
13/02/2006 09:40:45  InitStatNames starts
13/02/2006 09:40:45  select name from v$statname order by statistic#
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
                     SQL = select name from v$statname order by statistic#
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery End  (25 records processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery End  (25 records processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery End  (25 records processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery End  (25 records processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery End  (25 records processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery End  (25 records processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery End  (25 records processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery End  (25 records processed)
                     Duration = 0.016
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.DynamicQuery End  (11 records processed)
                     Duration = 0
13/02/2006 09:40:45  InitStatNames ends
13/02/2006 09:40:45  StatQuery.Describe starts
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.StatQuery Start Query.Describe
                     SQL = select value from v$sesstat where sid = :sid order by statistic#
                     :SID = Null
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.StatQuery End
                     Duration = 0
13/02/2006 09:40:45  StatQuery.Describe ends
13/02/2006 09:40:45  TStatistics.Init ends
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
                     SQL = select value from v$sesstat where sid = :sid order by statistic#
                     :SID = 19
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.StatQuery End  (211 records processed)
                     Duration = 0
13/02/2006 09:40:45  InitStatistics ends
13/02/2006 09:40:45  TSQLThread SQLThread.Execute
13/02/2006 09:40:45  TOracleQuery Query Start Query.Execute
                     SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
                     :ID = Null
13/02/2006 09:40:45  TOracleQuery Query End
                     Duration = 0.015
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Execute
                     SQL = SELECT *
                     FROM AID.DOSSIER D
                     WHERE D.DATENREG >= '09/12/2005'
                     AND D.DATENREG < '10/12/2005'
                     AND D.CODART = :CODART
                     :CODART = 27
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0.063
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0.015
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0.016
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (1 record processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery Start Query.Next for up to 1 record
13/02/2006 09:40:45  TOracleQuery TestForm.TestQuery End  (0 records processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery Query Start Query.Execute
                     SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
                     :ID = Null
13/02/2006 09:40:45  TOracleQuery Query End
                     Duration = 0
13/02/2006 09:40:45  TSQLThread SQLThread Postmessage
13/02/2006 09:40:45  TSQLThread SQLThread Suspend
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
                     SQL = select value from v$sesstat where sid = :sid order by statistic#
                     :SID = 19
13/02/2006 09:40:45  TOracleQuery PLSQLDevForm.StatQuery End  (211 records processed)
                     Duration = 0
13/02/2006 09:40:45  TOracleQuery 499C60 Start Query.Execute
                     SQL = begin
                       sys.dbms_output.get_line(line => :line, status => :status);
                     end;
                     :LINE = Null
                     :STATUS = Null
13/02/2006 09:40:45  TOracleQuery 499C60 End
                     Duration = 0
13/02/2006 09:40:45  GetHTPOutput starts
13/02/2006 09:40:45  TOracleQuery 499C60 Start Query.Execute
                     SQL = begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
13/02/2006 09:40:45  TOracleQuery 499C60 End
                     Duration = 0.015
13/02/2006 09:40:45  Trying htp.get_line
13/02/2006 09:40:45  TOracleQuery 499C60 Start Query.Execute
                     SQL = begin htp.flush; :line := htp.get_line(:rows); end;
                     :LINE = Null
                     :ROWS = Null
13/02/2006 09:40:45  TOracleQuery 499C60 End
                     Duration = 0
13/02/2006 09:40:45  No lines retrieved
13/02/2006 09:40:45  GetHTPOutput finished
13/02/2006 09:40:49  TOracleQuery Query Start Query.Execute
                     SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
                     :ID = Null
13/02/2006 09:40:49  TOracleQuery Query End
                     Duration = 0
 
Back
Top