A couple of minor bugs in 9.0

M

MjH

Member²
Note: I am running with 'Multiple Connections' turned off.

1) If you select 'Session -> Logoff', you get a dialog box with the message:

Could not logon as @
ORA-01005: null password given; logon denied

After pressing the the 'OK' button, the "Oracle Logon" dialog box appears, with all fields except "Password" un-enterable and greyed-out.

2) When logging into a different user/database with "Session -> Logon", the command "set prompt "[connection]"" does not always work for existing Command Windows. I've found that I need to repeat the logon in order for the prompt to change. This always worked in v8.

Thanks,
 
MjH said:
Note: I am running with 'Multiple Connections' turned off.

1) If you select 'Session -> Logoff', you get a dialog box with the message:

Could not logon as @
ORA-01005: null password given; logon denied

After pressing the the 'OK' button, the "Oracle Logon" dialog box appears, with all fields except "Password" un-enterable and greyed-out.
Click to expand...
I cannot reproduce this. 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 or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

MjH said:
2) When logging into a different user/database with "Session -> Logon", the command "set prompt "[connection]"" does not always work for existing Command Windows. I've found that I need to repeat the logon in order for the prompt to change. This always worked in v8.
Click to expand...
This is fixed for the upcoming 9.0.1 patch release.
 
Marco:

Here is the contents of Debug.txt

-------------------------------------------------------------

PL/SQL Developer
Version 9.0.0.1601
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4,194,304 kB (2,663,292 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,953,348 available)

Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe
DebugSQL

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

Preference Files

Plug-Ins

8/9/2011 9:11:05 AM Application started
8/9/2011 9:11:05 AM InitPreferences
8/9/2011 9:11:05 AM Load C:\Users\mhammel\AppData\Roaming\PLSQL Developer\Preferences\default = 0
8/9/2011 9:11:05 AM PreferenceSet.Load C:\Users\mhammel\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
8/9/2011 9:11:05 AM PreferenceSet.Load OK
8/9/2011 9:11:05 AM Determine LocalPrefPath
8/9/2011 9:11:05 AM [1]: C:\Users\mhammel\AppData\Roaming\PLSQL Developer\Preferences
8/9/2011 9:11:05 AM LocalPrefPath: C:\Users\mhammel\AppData\Roaming\PLSQL Developer\Preferences\mhammel
8/9/2011 9:11:05 AM Load C:\Users\mhammel\AppData\Roaming\PLSQL Developer\Preferences\mhammel = 0
8/9/2011 9:11:05 AM PreferenceSet.Load C:\Users\mhammel\AppData\Roaming\PLSQL Developer\Preferences\mhammel\default.ini
8/9/2011 9:11:05 AM PreferenceSet.Load OK
8/9/2011 9:11:05 AM PreferenceSet.Load C:\Users\mhammel\AppData\Roaming\PLSQL Developer\Preferences\mhammel\user.prefs
8/9/2011 9:11:05 AM PreferenceSet.Load OK
8/9/2011 9:11:05 AM InitPreferences end
8/9/2011 9:11:05 AM SortPreferenceSets
8/9/2011 9:11:05 AM - Default mhammel
8/9/2011 9:11:05 AM - System Default
8/9/2011 9:11:05 AM DoUpdateChildList
8/9/2011 9:11:05 AM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
8/9/2011 9:11:05 AM ReadString OK
8/9/2011 9:11:05 AM pfReadRegistry: "C:\Program Files (x86)\PLSQL Developer\PLSQLDev.exe" "%1"
8/9/2011 9:11:05 AM LoadPreferences
8/9/2011 9:11:05 AM LoadPreferences searching for default
8/9/2011 9:11:05 AM C:\Users\mhammel\AppData\Roaming\PLSQL Developer\Preferences\mhammel\default.ini
8/9/2011 9:11:05 AM LoadPreferences NewPref := nil
8/9/2011 9:11:05 AM LoadPreferences
8/9/2011 9:11:05 AM LoadPreferences Reading preferences
8/9/2011 9:11:05 AM LoadPreferences ReadPosition
8/9/2011 9:11:05 AM LoadPreferences ToolsBrowserItemClick(nil)
8/9/2011 9:11:05 AM LoadPreferences CreateBrowserFilters...
8/9/2011 9:11:05 AM LoadPreferences Files
8/9/2011 9:11:05 AM LoadPreferences Buttons
8/9/2011 9:11:05 AM LoadPreferences Printer
8/9/2011 9:11:05 AM LoadPreferences FileBrowserFolders
8/9/2011 9:11:05 AM LoadPreferences Connections
8/9/2011 9:11:05 AM LoadPreferences BrowserFolders
8/9/2011 9:11:05 AM LoadPreferences
8/9/2011 9:11:05 AM LoadPreferences end
8/9/2011 9:11:05 AM MacroLibFilename: C:\Program Files (x86)\PLSQL Developer\Macro\mhammel.emlib
8/9/2011 9:11:14 AM TOracleSession $06490050 Start Session.LogOn as user@database
8/9/2011 9:11:16 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
8/9/2011 9:11:16 AM TOracleQuery Query End (1 record processed)
Duration = 0
8/9/2011 9:11:16 AM TOracleSession $06490050 End
Duration = 1.529
8/9/2011 9:11:16 AM TOracleQuery $064443E0 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
8/9/2011 9:11:16 AM TOracleQuery $064443E0 End (1 record processed)
Duration = 0
8/9/2011 9:11:16 AM TOracleSession $064902F0 Start Session.LogOn as user@database
8/9/2011 9:11:16 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
8/9/2011 9:11:16 AM TOracleQuery Query End (1 record processed)
Duration = 0.015
8/9/2011 9:11:16 AM TOracleSession $064902F0 End
Duration = 0.093
8/9/2011 9:11:16 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
8/9/2011 9:11:16 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
8/9/2011 9:11:16 AM TOracleQuery Query End (5 records processed)
Duration = 0
8/9/2011 9:11:16 AM TOracleQuery $06444120 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)
8/9/2011 9:11:16 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
8/9/2011 9:11:16 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
8/9/2011 9:11:16 AM TOracleQuery $06444120 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
8/9/2011 9:11:16 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.016
8/9/2011 9:11:16 AM LogonHistorySave start
8/9/2011 9:11:16 AM TOracleQuery $06444540 Start Query.Execute
SQL = /*
The name + type results of these queries will be used by the Code Assistant
if the "Describe Context" option is enabled. After typing 3 or more characters
the Code Assistant will show a list of matching names.
Separate multiple queries with semi-colons and use the :schema bind variable
to restrict names to the currently connected user.
In case of an error the query results will be omitted. No error message will
be displayed.
Place this file in the PL/SQL Developer installation directory for all users,
or in the "%APPDATA%\PLSQL Developer" directory for a specific user.
*/
select object_name, object_type
from sys.all_objects o
where o.owner = :schema
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = CTI_DBA2
8/9/2011 9:11:16 AM ChangeUserPref LogonHistory,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM ChangeUserPref DSA,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM ChangeUserPref ColumnAssociations,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM ChangeUserPref ImportAssociations,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM ChangeUserPref BrowserFilters,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM ChangeUserPref FileBrowserFolders,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM ChangeUserPref Connections,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM ChangeUserPref BrowserFolders,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM ChangeUserPref SessionQueries,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM ChangeUserPref ExternalTools,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM ChangeUserPref Documents,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM ChangeUserPref Reports,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM ChangeUserPref CurrentConnections,
8/9/2011 9:11:16 AM ChangeUserPref end
8/9/2011 9:11:16 AM PreferenceSet.Save
8/9/2011 9:11:16 AM PreferenceSet Filename = C:\Users\mhammel\AppData\Roaming\PLSQL Developer\Preferences\mhammel\user.prefs
8/9/2011 9:11:16 AM PreferenceSet AltFile = user.prefs
8/9/2011 9:11:16 AM PreferenceSet.Save end
8/9/2011 9:11:16 AM LogonHistorySave end
8/9/2011 9:11:16 AM FormCreate Logon.Executed -1
8/9/2011 9:11:16 AM FormCreate SessionChanged
8/9/2011 9:11:16 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
8/9/2011 9:11:16 AM TOracleQuery Query End (5 records processed)
Duration = 0
8/9/2011 9:11:16 AM TOracleQuery $06444280 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
8/9/2011 9:11:16 AM TOracleQuery $06444280 End (1 record processed)
Duration = 0.032
8/9/2011 9:11:16 AM SessionChanged SetDBAViews
8/9/2011 9:11:16 AM TOracleQuery $06444280 Start Query.Execute
SQL = select null from all_synonyms where 1=0
8/9/2011 9:11:16 AM TOracleQuery $06444540 End (6 records processed)
Duration = 0.109
8/9/2011 9:11:16 AM TOracleQuery $06444540 Start Query.Execute
SQL =
select s.synonym_name as object_name, o.object_type
from sys.all_synonyms s, sys.all_objects o
where s.owner in ('PUBLIC', :schema)
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')
:SCHEMA = CTI_DBA2
8/9/2011 9:11:16 AM TOracleQuery $06444280 End (0 records processed)
Duration = 0.062
8/9/2011 9:11:16 AM TOracleQuery $06444280 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
8/9/2011 9:11:16 AM TOracleQuery $06444280 End (0 records processed)
Duration = 0.046
8/9/2011 9:11:16 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
8/9/2011 9:11:16 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
8/9/2011 9:11:16 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
8/9/2011 9:11:16 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
8/9/2011 9:11:16 AM TOracleQuery $06444280 Start Query.Execute
SQL = select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
8/9/2011 9:11:16 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.062
8/9/2011 9:11:16 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:16 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.016
8/9/2011 9:11:16 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:16 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.062
8/9/2011 9:11:16 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:16 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.015
8/9/2011 9:11:16 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:16 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.031
8/9/2011 9:11:16 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:16 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.016
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.016
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.031
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.015
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.016
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.016
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.031
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.031
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.016
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.016
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.016
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.031
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.016
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.015
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.016
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.015
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.016
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (25 records processed)
Duration = 0.015
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Next for up to 25 records
8/9/2011 9:11:17 AM TOracleQuery $06444280 End (12 records processed)
Duration = 0.016
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_objects where rownum < 1
8/9/2011 9:11:17 AM TOracleQuery $06444280 End
Duration = 0.047
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_tab_columns where rownum < 1
8/9/2011 9:11:17 AM TOracleQuery $06444280 End
Duration = 0.437
8/9/2011 9:11:17 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_col_comments where rownum < 1
8/9/2011 9:11:18 AM TOracleQuery $06444280 End
Duration = 0.156
8/9/2011 9:11:18 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_triggers where rownum < 1
8/9/2011 9:11:18 AM TOracleQuery $06444280 End
Duration = 0.546
8/9/2011 9:11:18 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_constraints where rownum < 1
8/9/2011 9:11:19 AM TOracleQuery $06444280 End
Duration = 0.826
8/9/2011 9:11:19 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_indexes where rownum < 1
8/9/2011 9:11:19 AM TOracleQuery $06444280 End
Duration = 0.234
8/9/2011 9:11:19 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_cons_columns where rownum < 1
8/9/2011 9:11:19 AM TOracleQuery $06444280 End
Duration = 0.14
8/9/2011 9:11:19 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_ind_columns where rownum < 1
8/9/2011 9:11:19 AM TOracleQuery $06444280 End
Duration = 0.094
8/9/2011 9:11:19 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_dependencies where rownum < 1
8/9/2011 9:11:20 AM TOracleQuery $06444280 End
Duration = 0.14
8/9/2011 9:11:20 AM TOracleQuery $06444120 Start Query.Describe
SQL = select * from sys.dba_tables where rownum < 1
8/9/2011 9:11:20 AM TOracleQuery $06444120 End
Duration = 0.14
8/9/2011 9:11:20 AM TOracleQuery $06444120 Start Query.Describe
SQL = select * from sys.dba_tab_comments where rownum < 1
8/9/2011 9:11:20 AM TOracleQuery $06444120 End
Duration = 0.032
8/9/2011 9:11:20 AM TOracleQuery $06444120 Start Query.Describe
SQL = select * from sys.dba_sequences where rownum < 1
8/9/2011 9:11:20 AM TOracleQuery $06444120 End
Duration = 0.031
8/9/2011 9:11:20 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_errors where rownum < 1
8/9/2011 9:11:20 AM TOracleQuery $06444280 End
Duration = 0.109
8/9/2011 9:11:20 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_source where rownum < 1
8/9/2011 9:11:20 AM TOracleQuery $06444280 End
Duration = 0.172
8/9/2011 9:11:20 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_views where rownum < 1
8/9/2011 9:11:20 AM TOracleQuery $06444280 End
Duration = 0.109
8/9/2011 9:11:20 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_synonyms where rownum < 1
8/9/2011 9:11:20 AM TOracleQuery $06444280 End
Duration = 0.047
8/9/2011 9:11:20 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_users where rownum < 1
8/9/2011 9:11:21 AM TOracleQuery $06444280 End
Duration = 0.468
8/9/2011 9:11:21 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_object_tables where rownum < 1
8/9/2011 9:11:21 AM TOracleQuery $06444280 End
Duration = 0.453
8/9/2011 9:11:21 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_type_attrs where rownum < 1
8/9/2011 9:11:22 AM TOracleQuery $06444280 End
Duration = 0.889
8/9/2011 9:11:22 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_type_methods where rownum < 1
8/9/2011 9:11:22 AM TOracleQuery $06444280 End
Duration = 0.094
8/9/2011 9:11:22 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_method_params where rownum < 1
8/9/2011 9:11:23 AM TOracleQuery $06444280 End
Duration = 0.468
8/9/2011 9:11:23 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_method_results where rownum < 1
8/9/2011 9:11:23 AM TOracleQuery $06444280 End
Duration = 0.359
8/9/2011 9:11:23 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_tab_privs where rownum < 1
8/9/2011 9:11:23 AM TOracleQuery $06444280 End
Duration = 0.234
8/9/2011 9:11:23 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_clusters where rownum < 1
8/9/2011 9:11:23 AM TOracleQuery $06444280 End
Duration = 0.125
8/9/2011 9:11:23 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_libraries where rownum < 1
8/9/2011 9:11:24 AM TOracleQuery $06444280 End
Duration = 0.14
8/9/2011 9:11:24 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_directories where rownum < 1
8/9/2011 9:11:24 AM TOracleQuery $06444280 End
Duration = 0.046
8/9/2011 9:11:24 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_jobs where rownum < 1
8/9/2011 9:11:24 AM TOracleQuery $06444280 End
Duration = 0.016
8/9/2011 9:11:24 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_db_links where rownum < 1
8/9/2011 9:11:24 AM TOracleQuery $06444280 End
Duration = 0.015
8/9/2011 9:11:24 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_mviews where rownum < 1
8/9/2011 9:11:24 AM TOracleQuery $06444280 End
Duration = 0.234
8/9/2011 9:11:24 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_snapshots where rownum < 1
8/9/2011 9:11:24 AM TOracleQuery $06444280 End
Duration = 0.187
8/9/2011 9:11:24 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_queues where rownum < 1
8/9/2011 9:11:24 AM TOracleQuery $06444280 End
Duration = 0.156
8/9/2011 9:11:24 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_queue_tables where rownum < 1
8/9/2011 9:11:24 AM TOracleQuery $06444280 End
Duration = 0.14
8/9/2011 9:11:24 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_types where rownum < 1
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 8.471
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.015
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.016
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.015
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.016
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.016
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.016
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444280 End
Duration = 0.452
8/9/2011 9:11:25 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_scheduler_jobs where rownum < 1
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.016
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.094
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.093
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.031
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.032
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444280 End
Duration = 0.312
8/9/2011 9:11:25 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_scheduler_program_args where rownum < 1
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.062
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.031
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.016
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.125
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.015
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:25 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.016
8/9/2011 9:11:25 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:26 AM TOracleQuery $06444280 End
Duration = 0.5
8/9/2011 9:11:26 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_scheduler_job_args where rownum < 1
8/9/2011 9:11:26 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.249
8/9/2011 9:11:26 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:26 AM TOracleQuery $06444280 End
Duration = 0.078
8/9/2011 9:11:26 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_scheduler_wingroup_members where rownum < 1
8/9/2011 9:11:26 AM TOracleQuery $06444280 End
Duration = 0.063
8/9/2011 9:11:26 AM TOracleQuery $06444280 Start Query.Describe
SQL = select * from sys.dba_scheduler_windows where rownum < 1
8/9/2011 9:11:26 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.156
8/9/2011 9:11:26 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
8/9/2011 9:11:26 AM TOracleQuery $06444280 End
Duration = 0.031
8/9/2011 9:11:26 AM SessionChanged Authorizations.Load
8/9/2011 9:11:26 AM SessionChanged EnableAuthorizedMenus
8/9/2011 9:11:26 AM ExecuteConnectScript starts
8/9/2011 9:11:26 AM TOracleQuery $06444280 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
8/9/2011 9:11:26 AM TOracleQuery $06444280 End
Duration = 0
8/9/2011 9:11:26 AM TOracleQuery $06444280 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
8/9/2011 9:11:26 AM TOracleQuery $06444280 End
Duration = 0
8/9/2011 9:11:26 AM TOracleQuery $06444280 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
8/9/2011 9:11:26 AM TOracleQuery $06444280 End
Duration = 0
8/9/2011 9:11:26 AM ExecuteConnectScript ends
8/9/2011 9:11:26 AM SetSessionAction starts: Primary Session
8/9/2011 9:11:26 AM TOracleQuery $06444280 Start Query.Execute
SQL = select null from dual
8/9/2011 9:11:26 AM TOracleQuery $06444280 End (1 record processed)
Duration = 0
8/9/2011 9:11:26 AM TOracleQuery $06444280 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
8/9/2011 9:11:26 AM TOracleQuery $06444280 End
Duration = 0.016
8/9/2011 9:11:26 AM SetSessionAction ends
8/9/2011 9:11:26 AM SessionChanged LoadRecentObjects
8/9/2011 9:11:26 AM SessionChanged Notify children
8/9/2011 9:11:26 AM SessionChanged Logoff secondary sessions
9/8/2011 9:11:26 AM SessionChanged EnableChildFunctions
9/8/2011 9:11:26 AM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: C:\Programs\Oracle\11gR2Client
Found: oci.dll
Using: C:\Programs\Oracle\11gR2Client\bin\oci.dll
9/8/2011 9:11:26 AM Lock
9/8/2011 9:11:26 AM UnLock
9/8/2011 9:11:26 AM Lock
9/8/2011 9:11:26 AM UnLock
9/8/2011 9:11:26 AM PlugIn Exception: "Favorites v2.1" OnCreate
9/8/2011 9:11:26 AM SortPreferenceSets
9/8/2011 9:11:26 AM - Default mhammel
9/8/2011 9:11:26 AM - System Default
9/8/2011 9:11:26 AM TOracleQuery $06444280 Start Query.Execute
SQL = select null from all_synonyms where 1=0
9/8/2011 9:11:26 AM TOracleQuery $06444280 End (0 records processed)
Duration = 0.015
9/8/2011 9:11:26 AM TOracleQuery $06444280 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
9/8/2011 9:11:26 AM TOracleQuery $06444280 End (0 records processed)
Duration = 0.016
9/8/2011 9:11:26 AM Lock
9/8/2011 9:11:26 AM UnLock
9/8/2011 9:11:26 AM DoUpdateChildList
9/8/2011 9:11:26 AM FormActivate start
9/8/2011 9:11:26 AM FormActivate end
9/8/2011 9:11:26 AM WMUpdatePopups starts
9/8/2011 9:11:27 AM GetCrashList: 5314360.cfg
9/8/2011 9:11:27 AM GetCrashList: 16387410.cfg
9/8/2011 9:11:27 AM GetCrashList: 11605944.cfg
9/8/2011 9:11:27 AM GetCrashList: 56695050.cfg
9/8/2011 9:11:27 AM LoadDesktop starts
9/8/2011 9:11:27 AM LoadDesktop Window = 4
9/8/2011 9:11:27 AM Create TCommandForm Start
9/8/2011 9:11:27 AM Create TCommandForm Inherited
9/8/2011 9:11:27 AM Create TCommandForm SetupMainFont
9/8/2011 9:11:27 AM Create TCommandForm Activate
9/8/2011 9:11:27 AM Create TCommandForm Activate done
9/8/2011 9:11:27 AM Create TCommandForm UpdateWindowList
9/8/2011 9:11:27 AM Create TCommandForm Positioning
9/8/2011 9:11:27 AM Create TCommandForm Finished
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM TOracleSession $064917F0 Start Session.LogOn as user@database
9/8/2011 9:11:27 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
9/8/2011 9:11:27 AM TOracleQuery Query End (1 record processed)
Duration = 0
9/8/2011 9:11:27 AM TOracleSession $064917F0 End
Duration = 0.234
9/8/2011 9:11:27 AM SetSessionAction starts: Secondary Session
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = select null from dual
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End (1 record processed)
Duration = 0
9/8/2011 9:11:27 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
9/8/2011 9:11:27 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.016
9/8/2011 9:11:27 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
9/8/2011 9:11:27 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Secondary Session
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End
Duration = 0
9/8/2011 9:11:27 AM SetSessionAction ends
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End (1 record processed)
Duration = 0
9/8/2011 9:11:27 AM SetConnected starts
9/8/2011 9:11:27 AM Already connected: check connection
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = select 'x' from dual
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End (1 record processed)
Duration = 0
9/8/2011 9:11:27 AM Using existing connection
9/8/2011 9:11:27 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
9/8/2011 9:11:27 AM TOracleQuery Query End (5 records processed)
Duration = 0
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM LoadDesktop ChildListIndex = 1
9/8/2011 9:11:27 AM LoadDesktop WindowName =
9/8/2011 9:11:27 AM SetSessionAction starts: Primary Session
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = select null from dual
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End (1 record processed)
Duration = 0
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End
Duration = 0
9/8/2011 9:11:27 AM SetSessionAction ends
9/8/2011 9:11:27 AM LoadDesktop Window = -1
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM NavigationBookmarks.EnableButtons(Rebuild)
9/8/2011 9:11:27 AM NavigationBookmarks: Backward=0, Forward=0
9/8/2011 9:11:27 AM DoUpdateChildList
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
9/8/2011 9:11:27 AM TOracleQuery Query End (5 records processed)
Duration = 0.016
9/8/2011 9:11:27 AM SessionChanged SetDBAViews
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End (0 records processed)
Duration = 0
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End (0 records processed)
Duration = 0
9/8/2011 9:11:27 AM SessionChanged Authorizations.Load
9/8/2011 9:11:27 AM SessionChanged ApplyPreferences
9/8/2011 9:11:27 AM SortPreferenceSets
9/8/2011 9:11:27 AM - Default mhammel
9/8/2011 9:11:27 AM - System Default
9/8/2011 9:11:27 AM SessionChanged EnableAuthorizedMenus
9/8/2011 9:11:27 AM ExecuteConnectScript starts
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End
Duration = 0.016
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End
Duration = 0
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End
Duration = 0
9/8/2011 9:11:27 AM ExecuteConnectScript ends
9/8/2011 9:11:27 AM SetSessionAction starts: Primary Session
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = select null from dual
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End (1 record processed)
Duration = 0
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
9/8/2011 9:11:27 AM TOracleQuery $06443FC0 End
Duration = 0
9/8/2011 9:11:27 AM SetSessionAction ends
9/8/2011 9:11:27 AM SessionChanged LoadRecentObjects
9/8/2011 9:11:27 AM SessionChanged Notify children
9/8/2011 9:11:27 AM SessionChanged Logoff secondary sessions
9/8/2011 9:11:27 AM SessionChanged EnableChildFunctions
9/8/2011 9:11:27 AM NavigationBookmarks.EnableButtons(Rebuild)
9/8/2011 9:11:27 AM NavigationBookmarks: Backward=0, Forward=0
9/8/2011 9:11:27 AM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: C:\Programs\Oracle\11gR2Client
Found: oci.dll
Using: C:\Programs\Oracle\11gR2Client\bin\oci.dll
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
9/8/2011 9:11:27 AM TOracleQuery Query End (5 records processed)
Duration = 0
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM LoadDesktop ends
9/8/2011 9:11:27 AM WMUpdatePopups ends
9/8/2011 9:11:27 AM NavigationBookmarks.EnableButtons(Rebuild)
9/8/2011 9:11:27 AM NavigationBookmarks: Backward=0, Forward=0
9/8/2011 9:11:27 AM InterpretLine starts: -- Autostart Command Window script
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: @\\nike\public\mhammel\Workstation\bin\sql\Setup.sql
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: set echo off
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: set feedback off
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts:
9/8/2011 9:11:27 AM InterpretLine starts: set pagesize 50000
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: set serveroutput on size 1000000
9/8/2011 9:11:27 AM SetConnected starts
9/8/2011 9:11:27 AM Already connected
9/8/2011 9:11:27 AM EnableOutput starts
9/8/2011 9:11:27 AM 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
9/8/2011 9:11:27 AM TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
9/8/2011 9:11:27 AM EnableOutput done
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: set linesize 10000
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: set define off
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: alter session set nls_date_format = 'dd-Mon-yyyy hh24:mi:ss';
9/8/2011 9:11:27 AM SetConnected starts
9/8/2011 9:11:27 AM Already connected
9/8/2011 9:11:27 AM NavigationBookmarks.EnableButtons(Rebuild)
9/8/2011 9:11:27 AM NavigationBookmarks: Backward=0, Forward=0
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM RSQLThread.Resume
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM TSQLThread SQLThread.Execute
9/8/2011 9:11:27 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
9/8/2011 9:11:27 AM TOracleQuery Query End
Duration = 0.016
9/8/2011 9:11:27 AM TOracleQuery CommandForm.Query Start Query.Execute
SQL =
alter session set nls_date_format = 'dd-Mon-yyyy hh24:mi:ss'
9/8/2011 9:11:27 AM TOracleQuery CommandForm.Query End
Duration = 0
9/8/2011 9:11:27 AM TSQLThread SQLThread Postmessage
9/8/2011 9:11:27 AM TSQLThread SQLThread Suspend
9/8/2011 9:11:27 AM Waiting for Suspension
9/8/2011 9:11:27 AM Done waiting for Suspension
9/8/2011 9:11:27 AM NavigationBookmarks.EnableButtons(Rebuild)
9/8/2011 9:11:27 AM NavigationBookmarks: Backward=0, Forward=0
9/8/2011 9:11:27 AM InterpretLine starts: alter session set nls_numeric_characters = ".,";
9/8/2011 9:11:27 AM SetConnected starts
9/8/2011 9:11:27 AM Already connected
9/8/2011 9:11:27 AM NavigationBookmarks.EnableButtons(Rebuild)
9/8/2011 9:11:27 AM NavigationBookmarks: Backward=0, Forward=0
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM RSQLThread.Resume
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM TSQLThread SQLThread Suspend ended
9/8/2011 9:11:27 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
9/8/2011 9:11:27 AM TOracleQuery Query End
Duration = 0
9/8/2011 9:11:27 AM TOracleQuery CommandForm.Query Start Query.Execute
SQL =
alter session set nls_numeric_characters = ".,"
9/8/2011 9:11:27 AM TOracleQuery CommandForm.Query End
Duration = 0
9/8/2011 9:11:27 AM TSQLThread SQLThread Postmessage
9/8/2011 9:11:27 AM TSQLThread SQLThread Suspend
9/8/2011 9:11:27 AM Waiting for Suspension
9/8/2011 9:11:27 AM Done waiting for Suspension
9/8/2011 9:11:27 AM NavigationBookmarks.EnableButtons(Rebuild)
9/8/2011 9:11:27 AM NavigationBookmarks: Backward=0, Forward=0
9/8/2011 9:11:27 AM InterpretLine starts: set long 5000
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts:
9/8/2011 9:11:27 AM InterpretLine starts: set define on;
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: define 1 = '%';
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: define 2 = '%';
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: define 3 = '%';
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: define 4 = '%';
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: define 5 = '%';
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: set define off;
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts:
9/8/2011 9:11:27 AM InterpretLine starts: set feedback on;
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: clear
9/8/2011 9:11:27 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
9/8/2011 9:11:27 AM TOracleQuery Query End (5 records processed)
Duration = 0
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts: prompt Setup done.
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM InterpretLine starts:
9/8/2011 9:11:27 AM InterpretLine starts: set prompt "[connection]"
9/8/2011 9:11:27 AM InterpretLine ends
9/8/2011 9:11:27 AM Lock
9/8/2011 9:11:27 AM UnLock
9/8/2011 9:11:27 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
9/8/2011 9:11:27 AM TOracleQuery Query End
Duration = 0.016
9/8/2011 9:11:27 AM NavigationBookmarks.EnableButtons(Rebuild)
9/8/2011 9:11:27 AM NavigationBookmarks: Backward=0, Forward=0
9/8/2011 9:11:28 AM TOracleQuery $06444540 End (100 records processed)
Duration = 1.887
9/8/2011 9:11:28 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:28 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.312
9/8/2011 9:11:28 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:28 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.39
9/8/2011 9:11:28 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:29 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.172
9/8/2011 9:11:29 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:29 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.093
9/8/2011 9:11:29 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:29 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.032
9/8/2011 9:11:29 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:29 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.124
9/8/2011 9:11:29 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:29 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.016
9/8/2011 9:11:29 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:29 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0
9/8/2011 9:11:29 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:29 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.219
9/8/2011 9:11:29 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:29 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.249
9/8/2011 9:11:29 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:30 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.234
9/8/2011 9:11:30 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:30 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0
9/8/2011 9:11:30 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:30 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.187
9/8/2011 9:11:30 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:30 AM TOracleQuery $06444540 End (100 records processed)
Duration = 0.265
9/8/2011 9:11:30 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:34 AM NavigationBookmarks.EnableButtons(Rebuild)
9/8/2011 9:11:34 AM NavigationBookmarks: Backward=0, Forward=0
9/8/2011 9:11:36 AM TOracleQuery $06443FC0 Start Query.Execute
SQL = select 'x' from dual
9/8/2011 9:11:36 AM TOracleQuery $06443FC0 End (1 record processed)
Duration = 0
9/8/2011 9:11:36 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
9/8/2011 9:11:36 AM TOracleQuery Query End
Duration = 0
9/8/2011 9:11:36 AM TOracleSession $064917F0 Start Session.LogOff
9/8/2011 9:11:36 AM TOracleSession $064917F0 End
Duration = 0
9/8/2011 9:11:36 AM TOracleSession $06490050 Start Session.LogOff
9/8/2011 9:11:36 AM TOracleSession $06490050 End
Duration = 0.016
9/8/2011 9:11:36 AM SessionChanged SetDBAViews
9/8/2011 9:11:36 AM SessionChanged Authorizations.Load
9/8/2011 9:11:36 AM SessionChanged ApplyPreferences
9/8/2011 9:11:36 AM SortPreferenceSets
9/8/2011 9:11:36 AM - Default mhammel
9/8/2011 9:11:36 AM - System Default
9/8/2011 9:11:36 AM SessionChanged EnableAuthorizedMenus
9/8/2011 9:11:36 AM ExecuteConnectScript starts
9/8/2011 9:11:36 AM ExecuteConnectScript ends
9/8/2011 9:11:36 AM SessionChanged LoadRecentObjects
9/8/2011 9:11:36 AM SessionChanged Notify children
9/8/2011 9:11:36 AM SessionChanged Logoff secondary sessions
9/8/2011 9:11:36 AM SessionChanged EnableChildFunctions
9/8/2011 9:11:36 AM NavigationBookmarks.EnableButtons(Rebuild)
9/8/2011 9:11:36 AM NavigationBookmarks: Backward=0, Forward=0
9/8/2011 9:11:36 AM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: C:\Programs\Oracle\11gR2Client
Found: oci.dll
Using: C:\Programs\Oracle\11gR2Client\bin\oci.dll
9/8/2011 9:11:36 AM Lock
9/8/2011 9:11:36 AM Lock
9/8/2011 9:11:36 AM UnLock
9/8/2011 9:11:36 AM UnLock
9/8/2011 9:11:36 AM SetConnected starts
9/8/2011 9:11:36 AM SetConnected: Disconnect starts
9/8/2011 9:11:36 AM TOracleSession $064917F0 Start Session.LogOn as user@database
9/8/2011 9:11:36 AM TOracleSession $064917F0 End
Result = ORA-01005: null password given; logon denied
Duration = 0.094
9/8/2011 9:11:36 AM SetConnected: ORA-01005: null password given; logon denied
9/8/2011 9:11:38 AM TOracleQuery $06444540 End (100 records processed)
Duration = 8.377
9/8/2011 9:11:38 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:42 AM TOracleQuery $06444540 End (100 records processed)
Duration = 3.713
9/8/2011 9:11:42 AM TOracleQuery $06444540 Start Query.Next for up to 100 records
9/8/2011 9:11:42 AM ExecuteConnectScript starts
9/8/2011 9:11:42 AM ExecuteConnectScript ends
9/8/2011 9:11:42 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
9/8/2011 9:11:42 AM TOracleQuery Query End
Result = Not logged on
Duration = 0
9/8/2011 9:11:42 AM Lock
9/8/2011 9:11:42 AM Lock
9/8/2011 9:11:42 AM UnLock
9/8/2011 9:11:42 AM UnLock
9/8/2011 9:11:45 AM MainForm Closing
9/8/2011 9:11:45 AM ChangeUserPref , PlanViewType
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref Logon, Username
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref Logon, Database
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref Logon, ConnectAs
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref , LastNewsRead
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref , LastNewsItem
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref , LastUpdateItem
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM MainForm Closed
9/8/2011 9:11:45 AM Destroying TCommandForm
9/8/2011 9:11:45 AM TSQLThread SQLThread Suspend ended
9/8/2011 9:11:45 AM Destroyed TCommandForm
9/8/2011 9:11:45 AM ChangeUserPref LogonHistory,
9/8/2011 9:11:45 AM ChangeUserPref DSA,
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref ColumnAssociations,
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref ImportAssociations,
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref BrowserFilters,
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref FileBrowserFolders,
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref Connections,
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref BrowserFolders,
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref SessionQueries,
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref ExternalTools,
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref Documents,
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref Reports,
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM ChangeUserPref CurrentConnections,
9/8/2011 9:11:45 AM ChangeUserPref end
9/8/2011 9:11:45 AM PreferenceSet.Save
9/8/2011 9:11:45 AM PreferenceSet Filename = C:\Users\mhammel\AppData\Roaming\PLSQL Developer\Preferences\mhammel\user.prefs
9/8/2011 9:11:45 AM PreferenceSet AltFile = user.prefs
9/8/2011 9:11:45 AM PreferenceSet.Save end
9/8/2011 9:11:45 AM Docking forms Destroying
9/8/2011 9:11:45 AM MainForm Destroying
9/8/2011 9:11:45 AM MainForm Destroyed
9/8/2011 9:11:45 AM Finalization HTMLUnit
9/8/2011 9:11:45 AM Finalization HTMLUnit done
9/8/2011 9:11:45 AM TOracleQuery $06444540 End
Result = ORA-01013: user requested cancel of current operation
Duration = 3.213
9/8/2011 9:11:45 AM TOracleSession $064902F0 Start Session.LogOff
9/8/2011 9:11:45 AM TOracleSession $064902F0 End
Duration = 0
9/8/2011 9:11:46 AM Finalization PLSCommon
9/8/2011 9:11:46 AM Finalization PLSCommon done
9/8/2011 9:11:46 AM Finalization HTMLUnit
9/8/2011 9:11:46 AM Finalization HTMLUnit done
9/8/2011 9:11:46 AM Finalization DBObjectUnit
9/8/2011 9:11:46 AM Finalization DBObjectUnit done
9/8/2011 9:11:46 AM Finalization PlanUnit
9/8/2011 9:11:46 AM Finalization PlanUnit done
9/8/2011 9:11:46 AM Finalization RepUnit
9/8/2011 9:11:46 AM Finalization RepUnit done
9/8/2011 9:11:46 AM Finalization ReportCommon
9/8/2011 9:11:46 AM Finalization ReportCommon done
9/8/2011 9:11:46 AM Finalization MacroUnit
9/8/2011 9:11:46 AM Finalization MacroUnit done
9/8/2011 9:11:46 AM Finalization StatUnit
9/8/2011 9:11:46 AM Finalization StatUnit done
9/8/2011 9:11:46 AM Finalization TotalRecallUnit
9/8/2011 9:11:46 AM Finalization TotalRecallUnit done
9/8/2011 9:11:46 AM Finalization RowExportUnit
9/8/2011 9:11:46 AM Finalization RowExportUnit done
 
Marco,

I also noticed the same behavior using the IDE_AddConnection/IDE_SetWindowConnection functions. If I add a new connection (with a password specified) and then call IDE_SetWindowConnection with the new connection index, it gives me the "ORA-01005: null password given" error popup, followed by the login prompt with all fields grayed out except the password field. If I re-enter the password, it works fine after that.

By the way, I've tried calling IDE_GetConnectionInfoEx immediately after IDE_AddConnection to verify that it has the password I passed to it, and it does.

Thanks!
Michael

Edit: I noticed that if I click cancel in the login window, it still establishes the new connection successfully anyway.
 
Last edited:
Marco, just to note that my first problem in the original post no longer occurs in 9.0.1.1619. So both problems have been rectified. Thanks.

There is a different behaviour in existing Command Windows now. Before, when you logged out, the prompt in the 'Dialog' tab of the Command Window would change to "not connected>" (or was it "not_connected>"?), and in 9.0.1.1619 it becomes "SQL>".

This is not really a problem (for me, anyway), but I thought I'd note it just in case.

 
You must log in or register to reply here.

Similar threads

Roeland
  • Discussion Discussion
Not Logged on... after logging in (Failing to set the main connection)
Replies
4
Views
6K
Marco Kalter
Marco Kalter
Claus Pedersen
  • Discussion Discussion
The value dialog box that pops up when a script encounter an &, pops up in front of other windows
Replies
1
Views
312
Marco Kalter
Marco Kalter
C
  • Discussion Discussion
Oracle Logon Prompt Error Message Adjustment
Replies
2
Views
445
Christopher Kennedy
C
Back
Top