If i break my debug in the middle of debugging session plsql is getting hanged. I am unable to perform any other operations. Kindly help on 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\<User>\AppData\Roaming\PLSQL Developer).

I Sent you a file to support@allroundautomations.com

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

Hi Marco,

i sent you several files, where breaking a debug session, causes to hang up PSD. Did this help in any way, or are there other ways we can help you to identify and fix this bug?

Regards Benjamin

Benjamin,

do you run the debug on a cluster?

If so: this generated errors and hanging PLSQL instances. Connect to a specific instance when debugging.

I everytime connect to a specific instance, we don't use clusters in our architecture.

i also have such problem!! i don't have clusters, simple 1 instance without links to remote db. very annoying, because restart the application didn't going successfull (old versions of edited files, old state of db objects)
Version 10.0.3.1701

I have this issue also and have posted on this site before about it. I have also seen many other posts regarding the same issue.

https://forums.allroundautomations.com/ubb//ubbthreads.php?ubb=showflat&Number=47034#Post47034

For me, it always occurs if, during debug, I hove the mouse over a line of code that is referencing a multi-level array. the above link gives a working example. It seems the guys at allround are not really interested in this as I've not seen one useful response to what is quite obviously a major bug.

Since most of our code base employs these structures it renders the pl/sql developer debugger pretty much useless as far as I am concerned. I think we will be moving back to Toad before long. It may be more expensive but at the very least you get responses from their support staff.

Any news on this bug? Any additional things we can do to help identifying the problem?

By now, you can't break any debug session, without killing PSD, and losing all unsaved programming results.

Very annoying and frustrating