sql window - single row button

[rbrooker]

i have a feeling that this should be disabled when there are no rows displayed in the grid.

i run a long query, the sql window tool bar appears while the query is running. clicking the single row button produces : "SingleRecordGrid : Row index 1 out of range"

thanks.

 

[Marco Kalter]

This is indeed a bug. We'll fix it.

 

[rbrooker]

this has not been fixed in 7.0.1

 

[Marco Kalter]

Works fine for me. Anything special I need to do to reproduce this?

 

[rbrooker]

execute a long running query, while it is running click on the single row button. the error appears.

 

[Marco Kalter]

Strange, this really works fine for me, and even more strangely we have actually reproduced the problem in 7.0.0 and fixed it in 7.0.1.

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.

 

[rbrooker]

PL/SQL Developer 7.0.1.1066 0x.0xxx - 1 user license
D:\Program Files\PLSQL Developer\plsqldev.exe

08/03/2006 09:00:50 Application started
08/03/2006 09:00:50 InitPreferences
08/03/2006 09:00:50 Load D:\Program Files\PLSQL Developer\Preferences\Default = 0
08/03/2006 09:00:50 PreferenceSet.Load D:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
08/03/2006 09:00:50 PreferenceSet.Load OK
08/03/2006 09:00:50 PreferenceSet.Save
08/03/2006 09:00:50 PreferenceSet filename = D:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
08/03/2006 09:00:50 PreferenceSet.Save end
08/03/2006 09:00:50 Load D:\Program Files\PLSQL Developer\Preferences\brookeri = 0
08/03/2006 09:00:50 PreferenceSet.Load D:\Program Files\PLSQL Developer\Preferences\brookeri\default.ini
08/03/2006 09:00:50 PreferenceSet.Load OK
08/03/2006 09:00:50 PreferenceSet.Save
08/03/2006 09:00:50 PreferenceSet filename = D:\Program Files\PLSQL Developer\Preferences\brookeri\default.ini
08/03/2006 09:00:50 PreferenceSet.Save end
08/03/2006 09:00:50 PreferenceSet.Load D:\Program Files\PLSQL Developer\Preferences\brookeri\user.prefs
08/03/2006 09:00:50 PreferenceSet.Load OK
08/03/2006 09:00:50 InitPreferences end
08/03/2006 09:00:50 SortPreferenceSets
08/03/2006 09:00:50 - Default brookeri
08/03/2006 09:00:50 - System Default
08/03/2006 09:00:50 LoadPreferences
08/03/2006 09:00:50 LoadPreferences searching for default
08/03/2006 09:00:50 D:\Program Files\PLSQL Developer\Preferences\brookeri\default.ini
08/03/2006 09:00:50 LoadPreferences end
08/03/2006 09:00:51 FormCreate TDBNames.Make
08/03/2006 09:00:51 FormCreate SessionChanged
08/03/2006 09:00:51 SessionChanged SetDBAViews
08/03/2006 09:00:51 SessionChanged Authorizations.Load
08/03/2006 09:00:51 SessionChanged EnableAuthorizedMenus
08/03/2006 09:00:51 ExecuteConnectScript starts
08/03/2006 09:00:51 ExecuteConnectScript ends
08/03/2006 09:00:51 SessionChanged LoadRecentObjects
08/03/2006 09:00:51 SessionChanged Notify children
08/03/2006 09:00:51 SessionChanged Logoff secondary sessions
08/03/2006 09:00:51 SessionChanged SessionMode = smMulti
08/03/2006 09:00:51 SessionChanged EnableChildFunctions
08/03/2006 09:00:51 SessionChanged
08/03/2006 09:00:52 SortPreferenceSets
08/03/2006 09:00:52 - Default brookeri
08/03/2006 09:00:52 - System Default
08/03/2006 09:00:59 TOracleSession PLSQLDevForm.Session Start Session.LogOn as pas@pas252.reswincoora0001.res.vuw.ac.nz
08/03/2006 09:00:59 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
08/03/2006 09:00:59 TOracleQuery Query End (1 record processed)
Duration = 0
08/03/2006 09:00:59 TOracleSession PLSQLDevForm.Session End
Duration = 0.191
08/03/2006 09:00:59 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
08/03/2006 09:00:59 TOracleQuery Query End (5 records processed)
Duration = 0.01
08/03/2006 09:00:59 SessionChanged SetDBAViews
08/03/2006 09:00:59 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
08/03/2006 09:00:59 TOracleQuery PLSQLDevForm.DynamicQuery End
Result = ORA-00942: table or view does not exist
Duration = 0
08/03/2006 09:00:59 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select object_name from sys.all_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
08/03/2006 09:00:59 TOracleQuery PLSQLDevForm.DynamicQuery End (2 records processed)
Duration = 0.02
08/03/2006 09:00:59 SessionChanged Authorizations.Load
08/03/2006 09:00:59 TOracleQuery $02233910 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)
08/03/2006 09:00:59 TOracleQuery $02233910 End
Result = ORA-00942: table or view does not exist
Duration = 0
08/03/2006 09:00:59 SessionChanged ApplyPreferences
08/03/2006 09:00:59 SortPreferenceSets
08/03/2006 09:00:59 - Default brookeri
08/03/2006 09:00:59 - System Default
08/03/2006 09:00:59 SessionChanged EnableAuthorizedMenus
08/03/2006 09:00:59 TOracleSession $0144D6E0 Start Session.LogOn as pas@pas252.reswincoora0001.res.vuw.ac.nz
08/03/2006 09:00:59 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
08/03/2006 09:00:59 TOracleQuery Query End (1 record processed)
Duration = 0
08/03/2006 09:00:59 TOracleSession $0144D6E0 End
Duration = 0.12
08/03/2006 09:00:59 SetSessionAction starts: Main session
08/03/2006 09:00:59 TOracleQuery $026A8B60 Start Query.Execute
SQL = select null from dual
08/03/2006 09:00:59 TOracleQuery $022337D0 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')
08/03/2006 09:00:59 TOracleQuery $026A8B60 End (1 record processed)
Duration = 0
08/03/2006 09:00:59 TOracleQuery $026A8B60 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
08/03/2006 09:00:59 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2 from dual
08/03/2006 09:00:59 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
08/03/2006 09:00:59 TOracleQuery $022337D0 End (75 records processed)
Duration = 0
08/03/2006 09:00:59 TOracleQuery $022337D0 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')
08/03/2006 09:00:59 TOracleQuery $026A8B60 End
Duration = 0
08/03/2006 09:00:59 SetSessionAction ends
08/03/2006 09:00:59 ExecuteConnectScript starts
08/03/2006 09:00:59 ExecuteConnectScript ends
08/03/2006 09:00:59 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
08/03/2006 09:00:59 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0.01
08/03/2006 09:00:59 SessionChanged LoadRecentObjects
08/03/2006 09:00:59 SessionChanged Notify children
08/03/2006 09:00:59 SessionChanged Logoff secondary sessions
08/03/2006 09:00:59 SessionChanged SessionMode = smMulti
08/03/2006 09:00:59 SessionChanged EnableChildFunctions
08/03/2006 09:00:59 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = Select banner from sys.v_$version where upper(banner) like upper('%Oracle%')
08/03/2006 09:00:59 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:00:59 TOracleQuery $022337D0 End (100 records processed)
Duration = 0.23
08/03/2006 09:00:59 TOracleQuery $022337D0 Start Query.Next for up to 100 records
08/03/2006 09:00:59 TOracleQuery $022337D0 End (100 records processed)
Duration = 0.01
08/03/2006 09:00:59 TOracleQuery $022337D0 Start Query.Next for up to 100 records
08/03/2006 09:00:59 TOracleQuery $022337D0 End (100 records processed)
Duration = 0.03
08/03/2006 09:00:59 TOracleQuery $022337D0 Start Query.Next for up to 100 records
08/03/2006 09:00:59 TOracleQuery $022337D0 End (100 records processed)
Duration = 0.01
08/03/2006 09:00:59 TOracleQuery $022337D0 Start Query.Next for up to 100 records
08/03/2006 09:00:59 TOracleQuery $022337D0 End (100 records processed)
Duration = 0.02
08/03/2006 09:00:59 TOracleQuery $022337D0 Start Query.Next for up to 100 records
08/03/2006 09:00:59 TOracleQuery $022337D0 End (100 records processed)
Duration = 0.01
08/03/2006 09:00:59 TOracleQuery $022337D0 Start Query.Next for up to 100 records
08/03/2006 09:00:59 TOracleQuery $022337D0 End (100 records processed)
Duration = 0.01
08/03/2006 09:00:59 TOracleQuery $022337D0 Start Query.Next for up to 100 records
08/03/2006 09:00:59 TOracleQuery $022337D0 End (100 records processed)
Duration = 0.01
08/03/2006 09:00:59 TOracleQuery $022337D0 Start Query.Next for up to 100 records
08/03/2006 09:00:59 TOracleQuery $022337D0 End (100 records processed)
Duration = 0.02
08/03/2006 09:00:59 TOracleQuery $022337D0 Start Query.Next for up to 100 records
08/03/2006 09:01:00 TOracleQuery $022337D0 End (32 records processed)
Duration = 0.111
08/03/2006 09:01:00 TOracleSession $0144D6E0 Start Session.LogOff
08/03/2006 09:01:00 TOracleSession $0144D6E0 End
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_role_privs where granted_role like 'DBA' and default_role like 'YES'
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_sys_privs where upper(privilege) like upper('SELECT ANY TABLE')
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_role_privs where granted_role like 'DBA' and default_role like 'YES'
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0.01
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_sys_privs where upper(privilege) like upper('DELETE ANY TABLE')
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_role_privs where granted_role like 'DBA' and default_role like 'YES'
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_sys_privs where upper(privilege) like upper('INSERT ANY TABLE')
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_role_privs where granted_role like 'DBA' and default_role like 'YES'
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0.01
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_sys_privs where upper(privilege) like upper('UPDATE ANY TABLE')
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_role_privs where granted_role like 'DBA' and default_role like 'YES'
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_sys_privs where upper(privilege) like upper('ALTER ANY INDEX')
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_role_privs where granted_role like 'DBA' and default_role like 'YES'
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_sys_privs where upper(privilege) like upper('ANALYZE ANY')
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0.01
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_role_privs where granted_role like 'DBA' and default_role like 'YES'
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_sys_privs where upper(privilege) like upper('SELECT ANY TABLE')
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_role_privs where granted_role like 'DBA' and default_role like 'YES'
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_sys_privs where upper(privilege) like upper('DROP USER')
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleSession $0144E6A0 Start Session.LogOn as pas@pas252.reswincoora0001.res.vuw.ac.nz
08/03/2006 09:01:00 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
08/03/2006 09:01:00 TOracleQuery Query End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleSession $0144E6A0 End
Duration = 0.08
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = BEGIN
SYS.DBMS_APPLICATION_INFO.SET_CLIENT_INFO('Plot Window (http://www.browserextender.com/products.php)');
END;
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = BEGIN
SYS.DBMS_APPLICATION_INFO.SET_MODULE('PL/SQL Developer Plot Window plug-in','Access Database');
END;
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End
Duration = 0
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select name from sys.v_$database
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.PlugInQuery End
Result = ORA-00942: table or view does not exist
Duration = 0.01
08/03/2006 09:01:00 Create TSQLForm
08/03/2006 09:01:00 SQLForm
08/03/2006 09:01:00 SQLForm Initializing...
08/03/2006 09:01:00 SetConnected starts
08/03/2006 09:01:00 SetConnected: Connect starts
08/03/2006 09:01:00 TOracleSession $0144EE80 Start Session.LogOn as pas@pas252.reswincoora0001.res.vuw.ac.nz
08/03/2006 09:01:00 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
08/03/2006 09:01:00 TOracleQuery Query End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleSession $0144EE80 End
Duration = 0.07
08/03/2006 09:01:00 SetConnected: (Dis)connect ends
08/03/2006 09:01:00 SetSessionAction starts: SQL Window - New
08/03/2006 09:01:00 TOracleQuery $02656B60 Start Query.Execute
SQL = select null from dual
08/03/2006 09:01:00 TOracleQuery $02656B60 End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery $02656B60 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
08/03/2006 09:01:00 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2 from dual
08/03/2006 09:01:00 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
08/03/2006 09:01:00 TOracleQuery $02656B60 End
Duration = 0
08/03/2006 09:01:00 SetSessionAction ends
08/03/2006 09:01:00 ExecuteConnectScript starts
08/03/2006 09:01:00 ExecuteConnectScript ends
08/03/2006 09:01:00 TOracleQuery $02656B60 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
08/03/2006 09:01:00 TOracleQuery $02656B60 End (1 record processed)
Duration = 0
08/03/2006 09:01:00 EnableOutput starts
08/03/2006 09:01:00 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
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
08/03/2006 09:01:00 EnableOutput done
08/03/2006 09:01:00 InitStatistics starts
08/03/2006 09:01:00 TStatistics.Init starts
08/03/2006 09:01:00 InitStatNames starts
08/03/2006 09:01:00 select name from v$statname order by statistic#
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select name from v$statname order by statistic#
08/03/2006 09:01:00 TOracleQuery PLSQLDevForm.DynamicQuery End
Result = ORA-00942: table or view does not exist
Duration = 0.01
08/03/2006 09:01:00 TStatistics.Init ends
08/03/2006 09:01:00 InitStatistics ends
08/03/2006 09:01:00 SQLForm Executing...
08/03/2006 09:01:00 SQLForm Executing...
08/03/2006 09:01:00 TSQLThread SQLThread.Execute
08/03/2006 09:01:00 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
08/03/2006 09:01:00 TOracleQuery Query End
Duration = 0
08/03/2006 09:01:00 TOracleQuery $02656DE0 Start Query.Execute
SQL = select * from v$instance
08/03/2006 09:01:00 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraHome10gr1
OracleHomeDir: D:\Oracle\ora10gr1
Found: oci.dll
Using: D:\Oracle\ora10gr1\bin\oci.dll
08/03/2006 09:01:00 TOracleQuery $02656DE0 End (1 record processed)
Duration = 0
08/03/2006 09:01:00 LogonHistorySave start
08/03/2006 09:01:00 ChangeUserPref LogonHistory,
08/03/2006 09:01:00 ChangeUserPref DSA,
08/03/2006 09:01:00 ChangeUserPref end
08/03/2006 09:01:00 ChangeUserPref ColumnAssociations,
08/03/2006 09:01:00 ChangeUserPref end
08/03/2006 09:01:00 ChangeUserPref ImportAssociations,
08/03/2006 09:01:00 ChangeUserPref end
08/03/2006 09:01:00 ChangeUserPref BrowserFilters,
08/03/2006 09:01:00 ChangeUserPref end
08/03/2006 09:01:00 ChangeUserPref BrowserFolders,
08/03/2006 09:01:00 ChangeUserPref end
08/03/2006 09:01:00 ChangeUserPref SessionQueries,
08/03/2006 09:01:00 ChangeUserPref end
08/03/2006 09:01:00 ChangeUserPref ExternalTools,
08/03/2006 09:01:00 ChangeUserPref end
08/03/2006 09:01:00 ChangeUserPref Documents,
08/03/2006 09:01:00 ChangeUserPref end
08/03/2006 09:01:00 ChangeUserPref Reports,
08/03/2006 09:01:00 ChangeUserPref end
08/03/2006 09:01:00 LogonHistorySave end
08/03/2006 09:01:00 TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM v$instance
08/03/2006 09:01:00 TOracleQuery SQLForm.TestQuery End
Duration = 0
08/03/2006 09:01:00 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
08/03/2006 09:01:00 TOracleQuery Query End
Duration = 0
08/03/2006 09:01:00 TSQLThread SQLThread Postmessage
08/03/2006 09:01:00 TSQLThread SQLThread Suspend
08/03/2006 09:01:00 TSQLForm.ThreadFinished
08/03/2006 09:01:00 TSQLForm.ThreadFinished: SQLThread.Suspended
08/03/2006 09:01:00 SQLForm 1 row selected in 0.191 seconds
08/03/2006 09:01:00 TOracleQuery $02656CA0 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
08/03/2006 09:01:00 TOracleQuery $02656CA0 End
Duration = 0
08/03/2006 09:01:00 SQLForm 1 row selected in 0.191 seconds
08/03/2006 09:01:07 SQLForm Initializing...
08/03/2006 09:01:07 SetConnected starts
08/03/2006 09:01:07 Already connected: check connection
08/03/2006 09:01:07 TOracleQuery $02656CA0 Start Query.Execute
SQL = select 'x' from dual
08/03/2006 09:01:07 TOracleQuery $02656CA0 End (1 record processed)
Duration = 0
08/03/2006 09:01:07 Using existing connection
08/03/2006 09:01:07 EnableOutput starts
08/03/2006 09:01:07 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
08/03/2006 09:01:07 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
08/03/2006 09:01:07 EnableOutput done
08/03/2006 09:01:07 InitStatistics starts
08/03/2006 09:01:07 InitStatistics ends
08/03/2006 09:01:07 SQLForm Executing...
08/03/2006 09:01:07 SQLForm Executing...
08/03/2006 09:01:07 TSQLThread SQLThread Suspend ended
08/03/2006 09:01:07 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
08/03/2006 09:01:07 TOracleQuery Query End
Duration = 0
08/03/2006 09:01:07 TOracleQuery $02656DE0 Start Query.Execute
SQL = select trunc(transactdatetime) "Date",
to_char(transactdatetime, 'Day') "Day",
sum(decode(transacttype, 'pr', 1, 0)) "Print transaction count",
sum(decode(transacttype, 'pr', abs(transactamount), 0)) "Charged Printing",
sum(decode(transacttype, 'px', 1, 0)) "Browse transaction count",
sum(decode(transacttype, 'px', abs(transactamount), 0)) "Charged Browsing",
nvl(trunc(sum(case transacttype
when 'px' then
decode(substr(description, 0, 11), 'Prod Zone 2', 1, 0)
end) / sum(decode(transacttype, 'px', 1, 0)) * 100), 100) "% free browsing"
from (select *
from pas.transact
union all
select *
from transact_arch)
where transactdatetime >= '09-FEB-2006'
group by trunc(transactdatetime),
to_char(transactdatetime, 'Day')
order by 1 desc
***********************************************************************************************
08/03/2006 09:01:09 Exception: SingleRecordGrid: Row index 1 out of range
***********************************************************************************************
08/03/2006 09:01:09 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
08/03/2006 09:01:09 TOracleQuery Query End (5 records processed)
Duration = 0
08/03/2006 09:01:50 TOracleQuery $02656B60 Start Query.Execute
SQL = select 'x' from dual
08/03/2006 09:01:50 TOracleQuery $02656B60 End (1 record processed)
Duration = 0
08/03/2006 09:02:50 TOracleQuery $02656B60 Start Query.Execute
SQL = select 'x' from dual
08/03/2006 09:02:50 TOracleQuery $02656B60 End (1 record processed)
Duration = 0
08/03/2006 09:03:12 TOracleQuery $02656DE0 End (28 records processed)
Duration = 124.048
08/03/2006 09:03:12 TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM select *
from pas.transact
union all
select *
from transact_arch
08/03/2006 09:03:12 TOracleQuery SQLForm.TestQuery End
Result = ORA-00903: invalid table name
Duration = 0
08/03/2006 09:03:12 SQLForm Executing... (10)
08/03/2006 09:03:12 SQLForm Executing... (20)
08/03/2006 09:03:12 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
08/03/2006 09:03:12 TOracleQuery Query End
Duration = 0
08/03/2006 09:03:12 TSQLThread SQLThread Postmessage
08/03/2006 09:03:12 TSQLThread SQLThread Suspend
08/03/2006 09:03:12 TSQLForm.ThreadFinished
08/03/2006 09:03:12 TSQLForm.ThreadFinished: SQLThread.Suspended
08/03/2006 09:03:12 SQLForm 28 rows selected in 124.139 seconds
08/03/2006 09:03:12 TOracleQuery $02656CA0 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
08/03/2006 09:03:12 TOracleQuery $02656CA0 End
Duration = 0
08/03/2006 09:03:12 SQLForm 28 rows selected in 124.139 seconds
08/03/2006 09:03:18 TOracleQuery $02656CA0 Start Query.Execute
SQL = select 'x' from dual
08/03/2006 09:03:18 TOracleQuery $02656CA0 End (1 record processed)
Duration = 0
08/03/2006 09:03:18 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
08/03/2006 09:03:18 TOracleQuery Query End
Duration = 0
08/03/2006 09:03:18 TOracleSession $0144E6A0 Start Session.LogOff
08/03/2006 09:03:18 TOracleSession $0144E6A0 End
Duration = 0
08/03/2006 09:03:18 MainForm Closing
08/03/2006 09:03:18 ChangeUserPref , PlanViewType
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref Logon, Username
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref Logon, Database
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref Logon, ConnectAs
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref , LastNewsRead
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref , LastNewsItem
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref , LastUpdateItem
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 TOracleSession PLSQLDevForm.Session Start Session.LogOff
08/03/2006 09:03:18 TOracleSession PLSQLDevForm.Session End
Duration = 0
08/03/2006 09:03:18 MainForm Closed
08/03/2006 09:03:18 Destroying TSQLForm
08/03/2006 09:03:18 TOracleSession $0144EE80 Start Session.LogOff
08/03/2006 09:03:18 TOracleSession $0144EE80 End
Duration = 0
08/03/2006 09:03:18 TSQLThread SQLThread Suspend ended
08/03/2006 09:03:18 Destroyed TSQLForm
08/03/2006 09:03:18 ChangeUserPref LogonHistory,
08/03/2006 09:03:18 ChangeUserPref DSA,
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref ColumnAssociations,
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref ImportAssociations,
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref BrowserFilters,
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref BrowserFolders,
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref SessionQueries,
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref ExternalTools,
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref Documents,
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 ChangeUserPref Reports,
08/03/2006 09:03:18 ChangeUserPref end
08/03/2006 09:03:18 MainForm Destroying
08/03/2006 09:03:18 MainForm Destroyed
08/03/2006 09:03:18 Finalization HTMLUnit
08/03/2006 09:03:18 Finalization HTMLUnit done
08/03/2006 09:03:19 Finalization PLSCommon
08/03/2006 09:03:19 Finalization PLSCommon done
08/03/2006 09:03:19 Finalization DBObjectUnit
08/03/2006 09:03:19 Finalization DBObjectUnit done
08/03/2006 09:03:19 Finalization RepUnit
08/03/2006 09:03:19 Finalization RepUnit done
08/03/2006 09:03:19 Finalization ReportCommon
08/03/2006 09:03:19 Finalization ReportCommon done
08/03/2006 09:03:19 Finalization PlanUnit
08/03/2006 09:03:19 Finalization PlanUnit done
08/03/2006 09:03:19 Finalization MacroUnit
08/03/2006 09:03:19 Finalization MacroUnit done
08/03/2006 09:03:19 Finalization StatUnit
08/03/2006 09:03:19 Finalization StatUnit done
08/03/2006 09:03:19 Finalization DBNamesUnit
08/03/2006 09:03:19 Finalization DBNamesUnit done
08/03/2006 09:03:19 Finalization TotalRecallUnit
08/03/2006 09:03:19 Finalization TotalRecallUnit done
08/03/2006 09:03:19 Finalization RowExportUnit
08/03/2006 09:03:19 Finalization RowExportUnit done

 

[Marco Kalter]

Sorry, my mistake. What I need is the plsqldev.log file.

 

[rbrooker]

there is no plsqldev.log file generated...