PL/SQL Developer
Version 7.1.5.1398
Windows 2003 Enterprise Edition (64-bit) 5.2 Build 3790 (Service Pack 2)
Physical memory : 4,194,304 kB (4,194,304 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (2,002,720 available)
Parameters
C:\PLSQLDEVELOPER\plsqldev.exe
DebugSQL
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Preference Files
Plug-Ins
4/18/2013 8:55:02 PM Application started
4/18/2013 8:55:02 PM InitPreferences
4/18/2013 8:55:02 PM Load C:\PLSQLDEVELOPER\Preferences\Default = 0
4/18/2013 8:55:02 PM PreferenceSet.Load C:\PLSQLDEVELOPER\Preferences\Default\Default.ini
4/18/2013 8:55:02 PM PreferenceSet.Load OK
4/18/2013 8:55:02 PM Determine LocalPrefPath
4/18/2013 8:55:02 PM [1]: C:\PLSQLDEVELOPER\Preferences
4/18/2013 8:55:02 PM LocalPrefPath: C:\PLSQLDEVELOPER\Preferences\119060
4/18/2013 8:55:02 PM Load C:\PLSQLDEVELOPER\Preferences\119060 = 0
4/18/2013 8:55:02 PM PreferenceSet.Load C:\PLSQLDEVELOPER\Preferences\119060\default.ini
4/18/2013 8:55:02 PM PreferenceSet.Load OK
4/18/2013 8:55:02 PM PreferenceSet.Load C:\PLSQLDEVELOPER\Preferences\119060\user.prefs
4/18/2013 8:55:02 PM PreferenceSet.Load OK
4/18/2013 8:55:02 PM InitPreferences end
4/18/2013 8:55:02 PM SortPreferenceSets
4/18/2013 8:55:02 PM - Default 119060
4/18/2013 8:55:02 PM - System Default
4/18/2013 8:55:02 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
4/18/2013 8:55:02 PM ReadString OK
4/18/2013 8:55:02 PM pfReadRegistry: "C:\PLSQLDEVELOPER\plsqldev.exe" "%1"
4/18/2013 8:55:02 PM LoadPreferences
4/18/2013 8:55:02 PM LoadPreferences searching for default
4/18/2013 8:55:02 PM C:\PLSQLDEVELOPER\Preferences\119060\default.ini
4/18/2013 8:55:02 PM LoadPreferences NewPref := nil
4/18/2013 8:55:02 PM LoadPreferences <section 2>
4/18/2013 8:55:02 PM LoadPreferences Reading preferences
4/18/2013 8:55:02 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
4/18/2013 8:55:02 PM ReadString OK
4/18/2013 8:55:02 PM pfReadRegistry: "C:\PLSQLDEVELOPER\plsqldev.exe" "%1"
4/18/2013 8:55:02 PM LoadPreferences ReadPosition
4/18/2013 8:55:02 PM LoadPreferences ToolsBrowserItemClick(nil)
4/18/2013 8:55:02 PM LoadPreferences CreateBrowserFilters...
4/18/2013 8:55:02 PM LoadPreferences Files
4/18/2013 8:55:02 PM LoadPreferences Logon
4/18/2013 8:55:02 PM LoadPreferences Buttons
4/18/2013 8:55:02 PM LoadPreferences Printer
4/18/2013 8:55:02 PM LoadPreferences BrowserFolders
4/18/2013 8:55:02 PM LoadPreferences <section 3>
4/18/2013 8:55:02 PM LoadPreferences end
4/18/2013 8:55:02 PM MacroLibFilename: C:\PLSQLDEVELOPER\Macro\119060.lib
4/18/2013 8:55:08 PM TOracleSession PLSQLDevForm.Session Start Session.LogOn as PMOUSER@RPNET02
4/18/2013 8:55:08 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
4/18/2013 8:55:08 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
4/18/2013 8:55:08 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
4/18/2013 8:55:08 PM TOracleQuery Query End (1 record processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleSession PLSQLDevForm.Session End
Duration = 0.25
4/18/2013 8:55:08 PM LogonHistorySave start
4/18/2013 8:55:08 PM ChangeUserPref LogonHistory,
4/18/2013 8:55:08 PM ChangeUserPref end
4/18/2013 8:55:08 PM ChangeUserPref DSA,
4/18/2013 8:55:08 PM ChangeUserPref end
4/18/2013 8:55:08 PM ChangeUserPref ColumnAssociations,
4/18/2013 8:55:08 PM ChangeUserPref end
4/18/2013 8:55:08 PM ChangeUserPref ImportAssociations,
4/18/2013 8:55:08 PM ChangeUserPref end
4/18/2013 8:55:08 PM ChangeUserPref BrowserFilters,
4/18/2013 8:55:08 PM ChangeUserPref end
4/18/2013 8:55:08 PM ChangeUserPref BrowserFolders,
4/18/2013 8:55:08 PM ChangeUserPref end
4/18/2013 8:55:08 PM ChangeUserPref SessionQueries,
4/18/2013 8:55:08 PM ChangeUserPref end
4/18/2013 8:55:08 PM ChangeUserPref ExternalTools,
4/18/2013 8:55:08 PM ChangeUserPref end
4/18/2013 8:55:08 PM ChangeUserPref Documents,
4/18/2013 8:55:08 PM ChangeUserPref end
4/18/2013 8:55:08 PM ChangeUserPref Reports,
4/18/2013 8:55:08 PM ChangeUserPref end
4/18/2013 8:55:08 PM PreferenceSet.Save
4/18/2013 8:55:08 PM PreferenceSet filename = C:\PLSQLDEVELOPER\Preferences\119060\user.prefs
4/18/2013 8:55:08 PM PreferenceSet.Save end
4/18/2013 8:55:08 PM LogonHistorySave end
4/18/2013 8:55:08 PM FormCreate Session.Connected
4/18/2013 8:55:08 PM FormCreate Logon.Executed -1
4/18/2013 8:55:08 PM FormCreate TDBNames.Make
4/18/2013 8:55:08 PM FormCreate SessionChanged
4/18/2013 8:55:08 PM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
4/18/2013 8:55:08 PM TOracleQuery Query End (5 records processed)
Duration = 0
4/18/2013 8:55:08 PM SessionChanged SetDBAViews
4/18/2013 8:55:08 PM TOracleQuery $0418AD60 Start Query.Execute
SQL = select null from all_synonyms where 1=0
4/18/2013 8:55:08 PM TOracleQuery $0418AD60 End (0 records processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleQuery $0418AD60 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
4/18/2013 8:55:08 PM TOracleQuery $0418AD60 End
Result = ORA-00942: table or view does not exist
Duration = 0
4/18/2013 8:55:08 PM SessionChanged Authorizations.Load
4/18/2013 8:55:08 PM TOracleQuery $0418AC00 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)
4/18/2013 8:55:08 PM TOracleQuery $0418AC00 End
Result = ORA-00942: table or view does not exist
Duration = 0
4/18/2013 8:55:08 PM SessionChanged EnableAuthorizedMenus
4/18/2013 8:55:08 PM TOracleSession $04A79A20 Start Session.LogOn as PMOUSER@RPNET02
4/18/2013 8:55:08 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
4/18/2013 8:55:08 PM TOracleQuery Query End (1 record processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleSession $04A79A20 End
Duration = 0.047
4/18/2013 8:55:08 PM SetSessionAction starts: Main session
4/18/2013 8:55:08 PM TOracleQuery $0418AD60 Start Query.Execute
SQL = select null from dual
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 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')
4/18/2013 8:55:08 PM TOracleQuery $0418AD60 End (1 record processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleQuery $0418AD60 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
4/18/2013 8:55:08 PM TOracleQuery $0418AD60 End
Duration = 0
4/18/2013 8:55:08 PM SetSessionAction ends
4/18/2013 8:55:08 PM ExecuteConnectScript starts
4/18/2013 8:55:08 PM ExecuteConnectScript ends
4/18/2013 8:55:08 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
4/18/2013 8:55:08 PM TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.016
4/18/2013 8:55:08 PM SessionChanged LoadRecentObjects
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:08 PM SessionChanged Notify children
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:08 PM SessionChanged Logoff secondary sessions
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:08 PM SessionChanged SessionMode = smMulti
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:08 PM SessionChanged EnableChildFunctions
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:08 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.016
4/18/2013 8:55:09 PM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: C:\app\119060\product\11.1.0\client_1
Found: oci.dll
Using: C:\app\119060\product\11.1.0\client_1\bin\oci.dll
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.015
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (66 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Execute
SQL = select s.synonym_name object_name, o.object_type
from all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
4/18/2013 8:55:09 PM SortPreferenceSets
4/18/2013 8:55:09 PM - Default 119060
4/18/2013 8:55:09 PM - System Default
4/18/2013 8:55:09 PM TOracleQuery $0418AAA0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
4/18/2013 8:55:09 PM TOracleQuery $0418AAA0 End (0 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AAA0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
4/18/2013 8:55:09 PM TOracleQuery $0418AAA0 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
4/18/2013 8:55:09 PM WMUpdatePopups starts
4/18/2013 8:55:09 PM GetCrashList: 196976.cfg
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.219
4/18/2013 8:55:09 PM GetCrashList: 460278.cfg
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM LoadDesktop starts
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM LoadDesktop ends
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM WMUpdatePopups ends
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.015
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.016
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.015
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.016
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.015
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.032
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.25
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.047
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.046
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.016
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.015
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.016
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.015
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.016
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (100 records processed)
Duration = 0.015
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 Start Query.Next for up to 100 records
4/18/2013 8:55:09 PM TOracleQuery $0418AEC0 End (98 records processed)
Duration = 0.016
4/18/2013 8:55:09 PM TOracleSession $04A79A20 Start Session.LogOff
4/18/2013 8:55:09 PM TOracleSession $04A79A20 End
Duration = 0.016
4/18/2013 8:55:11 PM AddPlugInPopups Start 0
4/18/2013 8:55:11 PM AddPlugInPopups End
4/18/2013 8:55:13 PM AddPlugInPopups Start 0
4/18/2013 8:55:13 PM AddPlugInPopups End
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Execute
SQL = select object_name, owner object_owner, status, object_type, created, last_ddl_time
from sys.all_objects o
where object_type = 'PACKAGE'
and object_name not like 'BIN$%'
order by decode(owner, user, 0, 1),
owner,
object_name
:OBJECT_TYPE = PACKAGE
:EXTRA_CONDITION =
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0.437
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 0
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
4/18/2013 8:55:15 PM TOracleQuery PLSQLDevForm.ObjectQuery End (10 records processed)
Duration = 0
4/18/2013 8:55:26 PM TOracleQuery $0418AAA0 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner = 'PMOUSER'
and po.object_name = 'PKG_PIPELINE'
and po.object_type = 'PACKAGE'
:OBJECT_OWNER = PMOUSER
:OBJECT_NAME = PKG_PIPELINE
:OBJECT_TYPE = PACKAGE
4/18/2013 8:55:26 PM TOracleQuery $0418AAA0 End (1 record processed)
Duration = 0.141
4/18/2013 8:55:26 PM AddPlugInPopups Start 0
4/18/2013 8:55:26 PM AddPlugInPopups End
4/18/2013 8:55:28 PM TOracleQuery $0418AAA0 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner = 'PMOUSER'
and po.object_name = 'PKG_PIPELINE'
and po.object_type = 'PACKAGE'
:OBJECT_OWNER = PMOUSER
:OBJECT_NAME = PKG_PIPELINE
:OBJECT_TYPE = PACKAGE
4/18/2013 8:55:28 PM TOracleQuery $0418AAA0 End (1 record processed)
Duration = 0
4/18/2013 8:55:28 PM AddPlugInPopups Start 0
4/18/2013 8:55:28 PM AddPlugInPopups End
4/18/2013 8:55:29 PM TOracleQuery $0418AAA0 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner = 'PMOUSER'
and po.object_name = 'PKG_PIPELINE_NEW_UI'
and po.object_type = 'PACKAGE'
:OBJECT_OWNER = PMOUSER
:OBJECT_NAME = PKG_PIPELINE_NEW_UI
:OBJECT_TYPE = PACKAGE
4/18/2013 8:55:29 PM TOracleQuery $0418AAA0 End (1 record processed)
Duration = 0.156
4/18/2013 8:55:29 PM AddPlugInPopups Start 0
4/18/2013 8:55:29 PM AddPlugInPopups End
4/18/2013 8:55:31 PM Create TProcEditForm Start
4/18/2013 8:55:31 PM Create TProcEditForm Inherited
4/18/2013 8:55:31 PM Create TProcEditForm SetupMainFont
4/18/2013 8:55:31 PM Create TProcEditForm Activate
4/18/2013 8:55:31 PM Create TProcEditForm Activate done
4/18/2013 8:55:31 PM Create TProcEditForm UpdateWindowList
4/18/2013 8:55:31 PM Create TProcEditForm Positioning
4/18/2013 8:55:31 PM Create TProcEditForm Finished
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Execute
SQL = select text from sys.all_source
where owner = :owner
and name = :name
and type = :type
order by line
:OWNER = PMOUSER
:NAME = PKG_PIPELINE_NEW_UI
:TYPE = PACKAGE
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0.015
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (60 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery PLSQLDevForm.ProgErrorQuery Start Query.Execute
SQL = select *
from sys.all_errors
where name = :name and type = :type and owner = :owner
order by sequence
:NAME = PKG_PIPELINE_NEW_UI
:TYPE = PACKAGE
:OWNER = PMOUSER
4/18/2013 8:55:31 PM TOracleQuery PLSQLDevForm.ProgErrorQuery End (0 records processed)
Duration = 0
4/18/2013 8:55:31 PM ProcEditForm.GetTabNames
4/18/2013 8:55:31 PM + PKG_PIPELINE_NEW_UI
4/18/2013 8:55:31 PM ProcEditForm.GetTabNames done
4/18/2013 8:55:31 PM NavigationBookmarks.EnableButtons(Rebuild)
4/18/2013 8:55:31 PM NavigationBookmarks: Backward=0, Forward=0
4/18/2013 8:55:31 PM UpdateContents(Clear)
4/18/2013 8:55:31 PM Source = CREATE OR REPLACE PACKAGE PKG_PIPELINE_NEW_UI IS
4/18/2013 8:55:31 PM UpdatingContents: Thread Started
4/18/2013 8:55:31 PM ContentsThread: Execute
4/18/2013 8:55:31 PM ContentsThread: Analyze
4/18/2013 8:55:31 PM ContentsThread: Valid
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Execute
SQL = select * from sys.all_objects
where object_type = :object_type
and owner = :object_owner
and object_name = :object_name
and :sub_object is null
:OBJECT_TYPE = PACKAGE BODY
:OBJECT_OWNER = PMOUSER
:OBJECT_NAME = PKG_PIPELINE_NEW_UI
:SUB_OBJECT = Null
4/18/2013 8:55:31 PM ContentsThread: Suspend started
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (1 record processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Execute
SQL = select text from sys.all_source
where owner = :owner
and name = :name
and type = :type
order by line
:OWNER = PMOUSER
:NAME = PKG_PIPELINE_NEW_UI
:TYPE = PACKAGE BODY
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0.125
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (44 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Execute
SQL = select text from sys.all_source
where owner = :owner
and name = :name
and type = :type
order by line
:OWNER = PMOUSER
:NAME = PKG_PIPELINE_NEW_UI
:TYPE = PACKAGE BODY
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (100 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 Start Query.Next for up to 100 records
4/18/2013 8:55:31 PM TOracleQuery $0418AD60 End (44 records processed)
Duration = 0
4/18/2013 8:55:31 PM TOracleQuery PLSQLDevForm.ProgErrorQuery Start Query.Execute
SQL = select *
from sys.all_errors
where name = :name and type = :type and owner = :owner
order by sequence
:NAME = PKG_PIPELINE_NEW_UI
:TYPE = PACKAGE BODY
:OWNER = PMOUSER
4/18/2013 8:55:31 PM TOracleQuery PLSQLDevForm.ProgErrorQuery End (0 records processed)
Duration = 0
4/18/2013 8:55:31 PM ProcEditForm.GetTabNames
4/18/2013 8:55:31 PM + PKG_PIPELINE_NEW_UI
4/18/2013 8:55:31 PM + PKG_PIPELINE_NEW_UI
4/18/2013 8:55:31 PM ProcEditForm.GetTabNames done
4/18/2013 8:55:31 PM NavigationBookmarks.EnableButtons(Rebuild)
4/18/2013 8:55:31 PM NavigationBookmarks: Backward=0, Forward=0
4/18/2013 8:55:31 PM UpdateContents(Clear)
4/18/2013 8:55:31 PM Source = CREATE OR REPLACE PACKAGE BODY PKG_PIPELINE_NEW_UI IS
4/18/2013 8:55:31 PM UpdatingContents: Thread Started
4/18/2013 8:55:31 PM ContentsThread: Resume
4/18/2013 8:55:31 PM ContentsThread: Analyze
4/18/2013 8:55:31 PM ContentsThread: Valid
4/18/2013 8:55:31 PM ContentsThread: Suspend started
4/18/2013 8:55:31 PM NavigationBookmarks.EnableButtons(Rebuild)
4/18/2013 8:55:31 PM NavigationBookmarks: Backward=0, Forward=0
4/18/2013 8:55:31 PM ContentsUpdated
4/18/2013 8:55:31 PM ContentsUpdated: Valid
4/18/2013 8:55:31 PM ContentsUpdated: Refresh Code Contents
4/18/2013 8:55:31 PM ContentsUpdated
4/18/2013 8:55:31 PM ContentsUpdated: Valid
4/18/2013 8:55:31 PM ContentsUpdated: Refresh Code Contents
4/18/2013 8:55:38 PM AddNavigationBookmark starts
4/18/2013 8:55:38 PM AddNavigationBookmark GNV00001
4/18/2013 8:55:38 PM NavigationBookmarks.EnableButtons(Rebuild)
4/18/2013 8:55:38 PM NavigationBookmarks: Backward=1, Forward=0
4/18/2013 8:55:38 PM AddNavigationBookmark ends
4/18/2013 8:55:39 PM TOracleQuery $0418AD60 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
4/18/2013 8:55:39 PM TOracleQuery $0418AD60 End (1 record processed)
Duration = 0
4/18/2013 8:55:39 PM TOracleQuery PLSQLDevForm.ResolveSymbolQuery Start Query.Execute
SQL = declare
t_owner varchar2(30);
t_name varchar2(30);
procedure check_mview is
dummy integer;
begin
if :object_type = 'TABLE' then
select 1 into dummy
from sys.all_objects
where owner = :object_owner
and object_name = :object_name
and object_type = 'MATERIALIZED VIEW'
and rownum = 1;
:object_type := 'MATERIALIZED VIEW';
end if;
exception
when others then null;
end;
begin
:sub_object := null;
if :deep != 0 then
begin
if :part2 is null then
select constraint_type, owner, constraint_name
into :object_type, :object_owner, :object_name
from sys.all_constraints c
where c.constraint_name = :part1 and c.owner = :cur_schema
and rownum = 1;
else
select constraint_type, owner, constraint_name, :part3
into :object_type, :object_owner, :object_name, :sub_object
from sys.all_constraints c
where c.constraint_name = :part2 and c.owner = :part1
and rownum = 1;
end if;
if :object_type = 'P' then :object_type := 'PRIMARY KEY'; end if;
if :object_type = 'U' then :object_type := 'UNIQUE KEY'; end if;
if :object_type = 'R' then :object_type := 'FOREIGN KEY'; end if;
if :object_type = 'C' then :object_type := 'CHECK CONSTRAINT'; end if;
return;
exception
when no_data_found then null;
end;
end if;
:sub_object := :part2;
if (:part2 is null) or (:part1 != :cur_schema) then
begin
select object_type, :cur_schema, :part1
into :object_type, :object_owner, :object_name
from sys.all_objects
where owner = :cur_schema
and object_name = :part1
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
if :object_type = 'SYNONYM' then
select s.table_owner, s.table_name
into t_owner, t_name
from all_synonyms s
where s.synonym_name = :part1
and s.owner = :cur_schema
and rownum = 1;
select o.object_type, o.owner, o.object_name
into :object_type, :object_owner, :object_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
end if;
:sub_object := :part2;
if :part3 is not null then
:sub_object := :sub_object || '.' || :part3;
end if;
check_mview;
return;
exception
when no_data_found then null;
end;
end if;
begin
select s.table_owner, s.table_name
into t_owner, t_name
from all_synonyms s
where s.synonym_name = :part1
and s.owner = 'PUBLIC'
and rownum = 1;
select o.object_type, o.owner, o.object_name
into :object_type, :object_owner, :object_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
:sub_object := :part3;
begin
select o.object_type, o.owner, o.object_name
into :object_type, :object_owner, :object_name
from sys.all_objects o
where o.owner = :part1
and o.object_name = :part2
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
begin
if :part2 is null and :part3 is null
then
select 'USER', null, :part1
into :object_type, :object_owner, :object_name
from sys.all_users u
where u.username = :part1
and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
begin
if :part2 is null and :part3 is null and :deep != 0
then
select 'ROLE', null, :part1
into :object_type, :object_owner, :object_name
from sys.session_roles r
where r.role = :part1
and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
:object_owner := null;
:object_type := null;
:object_name := null;
:sub_object := null;
end;
:PART1 = PMOUSER
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
:PART2 = PKG_PIPELINE_NEW_UI
:SUB_OBJECT = Null
:PART3 = SP_PIPELINE_MAIN
:DEEP = 0
:CUR_SCHEMA = PMOUSER
4/18/2013 8:55:39 PM TOracleQuery PLSQLDevForm.ResolveSymbolQuery End
Duration = 0.062
4/18/2013 8:55:39 PM TOracleQuery $0418AD60 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner = 'PMOUSER'
and po.object_name = 'PKG_PIPELINE_NEW_UI'
and po.object_type = 'PROCEDURE'
:OBJECT_OWNER = PMOUSER
:OBJECT_NAME = PKG_PIPELINE_NEW_UI
:OBJECT_TYPE = PROCEDURE
4/18/2013 8:55:39 PM TOracleQuery $0418AD60 End (0 records processed)
Duration = 0.156
4/18/2013 8:55:39 PM AddPlugInPopups Start 0
4/18/2013 8:55:39 PM AddPlugInPopups End
4/18/2013 8:55:40 PM TOracleQuery $0418AD60 Start Query.Execute
SQL = select * from sys.all_objects
where object_type = :object_type
and owner = :object_owner
and object_name = :object_name
and :sub_object is null
:OBJECT_TYPE = PACKAGE
:OBJECT_OWNER = PMOUSER
:OBJECT_NAME = PKG_PIPELINE_NEW_UI
:SUB_OBJECT = Null
4/18/2013 8:55:40 PM TOracleQuery $0418AD60 End (1 record processed)
Duration = 0
4/18/2013 8:55:40 PM TOracleQuery $0418AD60 Start Query.Execute
SQL = select * from sys.all_objects
where object_type = :object_type
and owner = :object_owner
and object_name = :object_name
and :sub_object is null
:OBJECT_TYPE = PACKAGE
:OBJECT_OWNER = PMOUSER
:OBJECT_NAME = PKG_PIPELINE_NEW_UI
:SUB_OBJECT = Null
4/18/2013 8:55:40 PM TOracleQuery $0418AD60 End (1 record processed)
Duration = 0
4/18/2013 8:55:40 PM Create TTestForm Start
4/18/2013 8:55:40 PM Create TTestForm Inherited
4/18/2013 8:55:40 PM NavigationBookmarks.EnableButtons(Rebuild)
4/18/2013 8:55:40 PM NavigationBookmarks: Backward=1, Forward=0
4/18/2013 8:55:40 PM AddNavigationBookmark starts
4/18/2013 8:55:40 PM AddNavigationBookmark GNV00002
4/18/2013 8:55:40 PM NavigationBookmarks.EnableButtons(Rebuild)
4/18/2013 8:55:40 PM NavigationBookmarks: Backward=2, Forward=0
4/18/2013 8:55:40 PM AddNavigationBookmark ends
4/18/2013 8:55:40 PM Create TTestForm SetupMainFont
4/18/2013 8:55:40 PM Create TTestForm Activate
4/18/2013 8:55:40 PM Create TTestForm Activate done
4/18/2013 8:55:40 PM Create TTestForm UpdateWindowList
4/18/2013 8:55:40 PM Create TTestForm Positioning
4/18/2013 8:55:40 PM Create TTestForm Finished
4/18/2013 8:55:40 PM NavigationBookmarks.EnableButtons(Rebuild)
4/18/2013 8:55:40 PM NavigationBookmarks: Backward=2, Forward=0
4/18/2013 8:55:52 PM SetConnected starts
4/18/2013 8:55:52 PM SetConnected: ForceLogoff starts
4/18/2013 8:55:52 PM SetConnected: ForceLogoff ends
4/18/2013 8:55:52 PM SetConnected: Connect starts
4/18/2013 8:55:52 PM TOracleSession $04A83500 Start Session.LogOn as PMOUSER@RPNET02
4/18/2013 8:55:52 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
4/18/2013 8:55:52 PM TOracleQuery Query End (1 record processed)
Duration = 0
4/18/2013 8:55:52 PM TOracleSession $04A83500 End
Duration = 0.031
4/18/2013 8:55:52 PM SetConnected: (Dis)connect ends
4/18/2013 8:55:52 PM SetSessionAction starts: Test Window - Script for procedure PKG_PIPELINE_NEW_UI.SP_PIPELINE_MAIN@RPNET02
4/18/2013 8:55:52 PM TOracleQuery $04AB6450 Start Query.Execute
SQL = select null from dual
4/18/2013 8:55:52 PM TOracleQuery $04AB6450 End (1 record processed)
Duration = 0
4/18/2013 8:55:52 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
4/18/2013 8:55:52 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
4/18/2013 8:55:52 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
4/18/2013 8:55:52 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
4/18/2013 8:55:52 PM TOracleQuery $04AB6450 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Test Window - Script for procedure PKG_PIPELINE_NEW_UI.SP_PIPELINE_MAIN@RPNET02
4/18/2013 8:55:52 PM TOracleQuery $04AB6450 End
Duration = 0
4/18/2013 8:55:52 PM SetSessionAction ends
4/18/2013 8:55:52 PM ExecuteConnectScript starts
4/18/2013 8:55:52 PM ExecuteConnectScript ends
4/18/2013 8:55:52 PM TOracleQuery $04AB6450 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
4/18/2013 8:55:52 PM TOracleQuery $04AB6450 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
4/18/2013 8:55:52 PM InitHTPOutput starts
4/18/2013 8:55:52 PM TOracleQuery $04AB6450 Start Query.Execute
SQL = begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
4/18/2013 8:55:52 PM TOracleQuery $04AB6450 End
Duration = 0
4/18/2013 8:55:52 PM InitHTPOutput finished
4/18/2013 8:55:52 PM EnableOutput starts
4/18/2013 8:55:52 PM 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
4/18/2013 8:55:52 PM TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
4/18/2013 8:55:52 PM EnableOutput done
4/18/2013 8:55:52 PM InitializeTargetSession starts
4/18/2013 8:55:52 PM TOracleQuery Debugger.InitializeTargetQuery Start Query.Execute
SQL = begin
--sys.dbms_session.reset_package;
sys.dbms_debug.probe_version(major => :major, minor => :minor);
:debug_session_id := sys.dbms_debug.initialize;
sys.dbms_debug.debug_on;
end;
:DEBUG_SESSION_ID = Null
:MAJOR = Null
:MINOR = Null
4/18/2013 8:55:52 PM TOracleQuery Debugger.InitializeTargetQuery End
Duration = 0.093
4/18/2013 8:55:52 PM TOracleSession Debugger.Session Start Session.LogOn as PMOUSER@RPNET02
4/18/2013 8:55:52 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
4/18/2013 8:55:52 PM TOracleQuery BytesPerCharacterQuery End (1 record proce