Print Thread
PL/SQL developer hangs upon Right clicking on Procedure, package, function
#33390 02/18/09 12:25 PM
Joined: Jan 2008
Posts: 11
I
iratta Offline OP
Member
OP Offline
Member
I
Joined: Jan 2008
Posts: 11
Version 7.1.5.1398 (100955.957)

When i right click on a procedure/function of any schema in a particular instance, the whole pl/sql developer program hangs. But i can right click and debug procs,packages on any other schema in any other instance.

Why is this happening?

Last edited by iratta; 02/18/09 12:26 PM.
Re: PL/SQL developer hangs upon Right clicking on Procedure, package, function
iratta #33396 02/18/09 12:51 PM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
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.


Marco Kalter
Allround Automations
Re: PL/SQL developer hangs upon Right clicking on Procedure, package, function
Marco Kalter #33400 02/19/09 06:23 AM
Joined: Jan 2008
Posts: 11
I
iratta Offline OP
Member
OP Offline
Member
I
Joined: Jan 2008
Posts: 11
here is the output

PL/SQL Developer
Version 7.1.5.1398
Windows 2003 Standard Edition 5.2 Build 3790 (Service Pack 2)

Physical memory : 2,086,916 kB (915,748 available)
Paging file : 4,031,188 kB (2,794,348 available)
Virtual memory : 2,097,024 kB (2,019,580 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
debugsql

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

Preference Files

Plug-Ins

19/02/2009 11:46:07 Application started
19/02/2009 11:46:07 InitPreferences
19/02/2009 11:46:07 Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
19/02/2009 11:46:07 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
19/02/2009 11:46:07 PreferenceSet.Load OK
19/02/2009 11:46:07 Determine LocalPrefPath
19/02/2009 11:46:07 [1]: C:\Program Files\PLSQL Developer\Preferences
19/02/2009 11:46:07 LocalPrefPath: C:\Program Files\PLSQL Developer\Preferences\amanu
19/02/2009 11:46:07 Load C:\Program Files\PLSQL Developer\Preferences\amanu = 0
19/02/2009 11:46:07 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\amanu\default.ini
19/02/2009 11:46:07 PreferenceSet.Load OK
19/02/2009 11:46:07 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\amanu\user.prefs
19/02/2009 11:46:07 PreferenceSet.Load OK
19/02/2009 11:46:07 InitPreferences end
19/02/2009 11:46:07 SortPreferenceSets
19/02/2009 11:46:07 - Default Amanu
19/02/2009 11:46:07 - System Default
19/02/2009 11:46:07 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
19/02/2009 11:46:07 ReadString OK
19/02/2009 11:46:07 pfReadRegistry: "C:\Program Files\PLSQL Developer\plsqldev.exe" "%1"
19/02/2009 11:46:07 LoadPreferences
19/02/2009 11:46:07 LoadPreferences searching for default
19/02/2009 11:46:07 C:\Program Files\PLSQL Developer\Preferences\amanu\default.ini
19/02/2009 11:46:07 LoadPreferences NewPref := nil
19/02/2009 11:46:07 LoadPreferences <section 2>
19/02/2009 11:46:07 LoadPreferences Reading preferences
19/02/2009 11:46:07 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
19/02/2009 11:46:07 ReadString OK
19/02/2009 11:46:07 pfReadRegistry: "C:\Program Files\PLSQL Developer\plsqldev.exe" "%1"
19/02/2009 11:46:07 LoadPreferences ReadPosition
19/02/2009 11:46:07 LoadPreferences ToolsBrowserItemClick(nil)
19/02/2009 11:46:07 LoadPreferences CreateBrowserFilters...
19/02/2009 11:46:07 LoadPreferences Files
19/02/2009 11:46:07 LoadPreferences Logon
19/02/2009 11:46:07 LoadPreferences Buttons
19/02/2009 11:46:07 LoadPreferences Printer
19/02/2009 11:46:07 LoadPreferences BrowserFolders
19/02/2009 11:46:07 LoadPreferences <section 3>
19/02/2009 11:46:07 LoadPreferences end
19/02/2009 11:46:07 MacroLibFilename: C:\Program Files\PLSQL Developer\Macro\amanu.lib
19/02/2009 11:46:17 TOracleSession PLSQLDevForm.Session Start Session.LogOn as ADDR2006R10QA@ORA214
19/02/2009 11:46:17 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
19/02/2009 11:46:17 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.016
19/02/2009 11:46:17 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
19/02/2009 11:46:17 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
19/02/2009 11:46:17 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
19/02/2009 11:46:17 TOracleQuery Query End (1 record processed)
Duration = 0
19/02/2009 11:46:17 TOracleSession PLSQLDevForm.Session End
Duration = 0.156
19/02/2009 11:46:17 LogonHistorySave start
19/02/2009 11:46:17 ChangeUserPref LogonHistory,
19/02/2009 11:46:17 ChangeUserPref DSA,
19/02/2009 11:46:17 ChangeUserPref end
19/02/2009 11:46:17 ChangeUserPref ColumnAssociations,
19/02/2009 11:46:17 ChangeUserPref end
19/02/2009 11:46:17 ChangeUserPref ImportAssociations,
19/02/2009 11:46:17 ChangeUserPref end
19/02/2009 11:46:17 ChangeUserPref BrowserFilters,
19/02/2009 11:46:17 ChangeUserPref end
19/02/2009 11:46:17 ChangeUserPref BrowserFolders,
19/02/2009 11:46:18 ChangeUserPref end
19/02/2009 11:46:18 ChangeUserPref SessionQueries,
19/02/2009 11:46:18 ChangeUserPref end
19/02/2009 11:46:18 ChangeUserPref ExternalTools,
19/02/2009 11:46:18 ChangeUserPref end
19/02/2009 11:46:18 ChangeUserPref Documents,
19/02/2009 11:46:18 ChangeUserPref end
19/02/2009 11:46:18 ChangeUserPref Reports,
19/02/2009 11:46:18 ChangeUserPref end
19/02/2009 11:46:18 LogonHistorySave end
19/02/2009 11:46:18 FormCreate Session.Connected
19/02/2009 11:46:18 FormCreate Logon.Executed -1
19/02/2009 11:46:18 FormCreate TDBNames.Make
19/02/2009 11:46:18 FormCreate SessionChanged
19/02/2009 11:46:18 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
19/02/2009 11:46:18 TOracleQuery Query End (5 records processed)
Duration = 0
19/02/2009 11:46:18 SessionChanged SetDBAViews
19/02/2009 11:46:18 TOracleQuery $02D2C730 Start Query.Execute
SQL = select null from all_synonyms where 1=0
19/02/2009 11:46:18 TOracleQuery $02D2C730 End (0 records processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C730 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
19/02/2009 11:46:18 TOracleQuery $02D2C730 End (0 records processed)
Duration = 0.016
19/02/2009 11:46:18 SessionChanged Authorizations.Load
19/02/2009 11:46:18 TOracleQuery $02D2C5D0 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)
19/02/2009 11:46:18 TOracleQuery $02D2C5D0 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
19/02/2009 11:46:18 SessionChanged EnableAuthorizedMenus
19/02/2009 11:46:18 TOracleSession $03650EA0 Start Session.LogOn as ADDR2006R10QA@ORA214
19/02/2009 11:46:18 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
19/02/2009 11:46:18 TOracleQuery Query End (1 record processed)
Duration = 0
19/02/2009 11:46:18 TOracleSession $03650EA0 End
Duration = 0.094
19/02/2009 11:46:18 SetSessionAction starts: Main session
19/02/2009 11:46:18 TOracleQuery $02D2C890 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')
19/02/2009 11:46:18 TOracleQuery $02D2C730 Start Query.Execute
SQL = select null from dual
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C730 End (1 record processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery $02D2C730 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.015
19/02/2009 11:46:18 TOracleQuery $02D2C730 End
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 SetSessionAction ends
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:18 ExecuteConnectScript starts
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 ExecuteConnectScript ends
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:18 SessionChanged LoadRecentObjects
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 SessionChanged Notify children
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.016
19/02/2009 11:46:18 SessionChanged Logoff secondary sessions
19/02/2009 11:46:18 SessionChanged SessionMode = smMulti
19/02/2009 11:46:18 SessionChanged EnableChildFunctions
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.016
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraDb10g_home2
OracleHomeDir: C:\oracle\product\10.2.0\db_2
Found: oci.dll
Using: C:\oracle\product\10.2.0\db_2\bin\oci.dll
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (84 records processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 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')
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = Select banner from sys.v_$version where upper(banner) like upper('%Oracle%')
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_role_privs where granted_role like 'DBA' and default_role like 'YES'
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0.016
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_sys_privs where upper(privilege) like upper('DROP USER')
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.109
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_role_privs where granted_role like 'DBA' and default_role like 'YES'
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.016
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_sys_privs where upper(privilege) like upper('ALTER ANY CLUSTER')
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0.016
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.015
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_role_privs where granted_role like 'DBA' and default_role like 'YES'
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.016
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select count(*) from user_sys_privs where upper(privilege) like upper('DROP ANY TABLE')
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.016
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:18 SortPreferenceSets
19/02/2009 11:46:18 - Default Amanu
19/02/2009 11:46:18 - System Default
19/02/2009 11:46:18 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.016
19/02/2009 11:46:18 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.015
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C470 Start Query.Execute
SQL = select null from all_synonyms where 1=0
19/02/2009 11:46:19 TOracleQuery $02D2C470 End (0 records processed)
Duration = 0
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.016
19/02/2009 11:46:19 TOracleQuery $02D2C470 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C470 End (0 records processed)
Duration = 0
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.016
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.016
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:19 WMUpdatePopups starts
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 LoadDesktop starts
19/02/2009 11:46:19 LoadDesktop ends
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:19 WMUpdatePopups ends
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.016
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0.016
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (100 records processed)
Duration = 0
19/02/2009 11:46:19 TOracleQuery $02D2C890 Start Query.Next for up to 100 records
19/02/2009 11:46:19 TOracleQuery $02D2C890 End (27 records processed)
Duration = 0.016
19/02/2009 11:46:19 TOracleSession $03650EA0 Start Session.LogOff
19/02/2009 11:46:19 TOracleSession $03650EA0 End
Duration = 0
19/02/2009 11:46:21 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 = 'PROCEDURE'
and object_name not like 'BIN$%'

order by decode(owner, user, 0, 1),
owner,
object_name
:OBJECT_TYPE = PROCEDURE
:EXTRA_CONDITION =
19/02/2009 11:46:25 TOracleQuery PLSQLDevForm.ObjectQuery End (100 records processed)
Duration = 3.688
19/02/2009 11:46:25 TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
19/02/2009 11:46:25 TOracleQuery PLSQLDevForm.ObjectQuery End (5 records processed)
Duration = 0
19/02/2009 11:46:37 TOracleQuery $02D2C470 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner = 'ADDR2006R10QA'
and po.object_name = 'C_FORCE_PARCL_SINGLE_TO_CHUTES'
and po.object_type = 'PROCEDURE'
:OBJECT_OWNER = ADDR2006R10QA
:OBJECT_NAME = C_FORCE_PARCL_SINGLE_TO_CHUTES
:OBJECT_TYPE = PROCEDURE
19/02/2009 11:46:37 TOracleQuery $02D2C470 End (1 record processed)
Duration = 0.125
19/02/2009 11:46:37 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = --
-- you must have granted select on sys.v_$db_object_cache
--
select decode(kept,'YES','UnKeep','Keep') caption
from sys.v_$db_object_cache
where owner like 'ADDR2006R10QA'
and name like 'C_FORCE_PARCL_SINGLE_TO_CHUTES'
and type like 'PROCEDURE'
union
select 'Keep' caption from dual
order by 1 desc
19/02/2009 11:46:58 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 20.438
19/02/2009 11:46:58 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select status
from sys.all_objects
where owner = 'ADDR2006R10QA'
and object_name ='C_FORCE_PARCL_SINGLE_TO_CHUTES'
19/02/2009 11:46:58 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0.11
19/02/2009 11:46:58 AddPlugInPopups Start 3
19/02/2009 11:46:58 Active Query Builder
19/02/2009 11:46:58 Browser Extender version 2.0 by Joachim Rupik
19/02/2009 11:46:58 Index
19/02/2009 11:46:58 Table
19/02/2009 11:46:58 User
19/02/2009 11:46:58 Tablespace
19/02/2009 11:46:58 Function
19/02/2009 11:46:58 Package
19/02/2009 11:46:58 Package body
19/02/2009 11:46:58 PROCEDURE
19/02/2009 11:46:58 AddMenu
19/02/2009 11:46:58 AddMenu Keep
19/02/2009 11:46:58 Sequence
19/02/2009 11:46:58 Trigger
19/02/2009 11:46:58 Type
19/02/2009 11:46:58 Type body
19/02/2009 11:46:58 Database link
19/02/2009 11:46:58 Directory
19/02/2009 11:46:58 Foreign Key
19/02/2009 11:46:58 Function
19/02/2009 11:46:58 Index
19/02/2009 11:46:58 Package
19/02/2009 11:46:58 Package body
19/02/2009 11:46:58 Primary Key
19/02/2009 11:46:58 PROCEDURE
19/02/2009 11:46:58 AddMenu
19/02/2009 11:46:58 AddMenu >>> VALID <<<
19/02/2009 11:46:58 Sequence
19/02/2009 11:46:58 Synonym
19/02/2009 11:46:58 Table
19/02/2009 11:46:58 Trigger
19/02/2009 11:46:58 Unique Key
19/02/2009 11:46:58 View
19/02/2009 11:46:58 Table
19/02/2009 11:46:58 Table
19/02/2009 11:46:58 Table
19/02/2009 11:46:58 Version Control Interface 1.2
19/02/2009 11:46:58 ProcedureWindow
19/02/2009 11:46:58 SQLWindow
19/02/2009 11:46:58 TestWindow
19/02/2009 11:46:58 CommandWindow
19/02/2009 11:46:58 ProcedureWindow
19/02/2009 11:46:58 SQLWindow
19/02/2009 11:46:58 TestWindow
19/02/2009 11:46:58 CommandWindow
19/02/2009 11:46:58 ProcedureWindow
19/02/2009 11:46:58 SQLWindow
19/02/2009 11:46:58 TestWindow
19/02/2009 11:46:58 CommandWindow
19/02/2009 11:46:58 ProcedureWindow
19/02/2009 11:46:58 SQLWindow
19/02/2009 11:46:58 TestWindow
19/02/2009 11:46:58 CommandWindow
19/02/2009 11:46:58 ProcedureWindow
19/02/2009 11:46:58 SQLWindow
19/02/2009 11:46:58 TestWindow
19/02/2009 11:46:58 CommandWindow
19/02/2009 11:46:58 ProcedureWindow
19/02/2009 11:46:58 SQLWindow
19/02/2009 11:46:58 TestWindow
19/02/2009 11:46:58 CommandWindow
19/02/2009 11:46:58 VIEW
19/02/2009 11:46:58 PACKAGE
19/02/2009 11:46:58 PACKAGE BODY
19/02/2009 11:46:58 TYPE
19/02/2009 11:46:58 TYPE BODY
19/02/2009 11:46:58 FUNCTION
19/02/2009 11:46:58 PROCEDURE
19/02/2009 11:46:58 AddMenu
19/02/2009 11:46:58 AddMenu -
19/02/2009 11:46:58 TRIGGER
19/02/2009 11:46:58 VIEW+
19/02/2009 11:46:58 PACKAGE+
19/02/2009 11:46:58 PACKAGE BODY+
19/02/2009 11:46:58 TYPE+
19/02/2009 11:46:58 TYPE BODY+
19/02/2009 11:46:58 FUNCTION+
19/02/2009 11:46:58 PROCEDURE+
19/02/2009 11:46:59 AddMenu
19/02/2009 11:46:59 AddMenu Check Out
19/02/2009 11:46:59 TRIGGER+
19/02/2009 11:46:59 VIEW+
19/02/2009 11:46:59 PACKAGE+
19/02/2009 11:46:59 PACKAGE BODY+
19/02/2009 11:46:59 TYPE+
19/02/2009 11:46:59 TYPE BODY+
19/02/2009 11:46:59 FUNCTION+
19/02/2009 11:46:59 PROCEDURE+
19/02/2009 11:46:59 AddMenu
19/02/2009 11:46:59 AddMenu Check In
19/02/2009 11:46:59 TRIGGER+
19/02/2009 11:46:59 VIEW+
19/02/2009 11:46:59 PACKAGE+
19/02/2009 11:46:59 PACKAGE BODY+
19/02/2009 11:46:59 TYPE+
19/02/2009 11:46:59 TYPE BODY+
19/02/2009 11:46:59 FUNCTION+
19/02/2009 11:46:59 PROCEDURE+
19/02/2009 11:46:59 AddMenu
19/02/2009 11:46:59 AddMenu Undo Check Out
19/02/2009 11:46:59 TRIGGER+
19/02/2009 11:46:59 VIEW+
19/02/2009 11:46:59 PACKAGE+
19/02/2009 11:46:59 PACKAGE BODY+
19/02/2009 11:46:59 TYPE+
19/02/2009 11:46:59 TYPE BODY+
19/02/2009 11:46:59 FUNCTION+
19/02/2009 11:46:59 PROCEDURE+
19/02/2009 11:46:59 AddMenu
19/02/2009 11:46:59 AddMenu Get from VCS
19/02/2009 11:46:59 TRIGGER+
19/02/2009 11:46:59 VIEW+
19/02/2009 11:46:59 PACKAGE+
19/02/2009 11:46:59 PACKAGE BODY+
19/02/2009 11:46:59 TYPE+
19/02/2009 11:46:59 TYPE BODY+
19/02/2009 11:46:59 FUNCTION+
19/02/2009 11:46:59 PROCEDURE+
19/02/2009 11:46:59 AddMenu
19/02/2009 11:46:59 AddMenu Add to VCS
19/02/2009 11:46:59 TRIGGER+
19/02/2009 11:46:59 VIEW
19/02/2009 11:46:59 PACKAGE
19/02/2009 11:46:59 PACKAGE BODY
19/02/2009 11:46:59 TYPE
19/02/2009 11:46:59 TYPE BODY
19/02/2009 11:46:59 FUNCTION
19/02/2009 11:46:59 PROCEDURE
19/02/2009 11:46:59 AddMenu
19/02/2009 11:46:59 AddMenu Properties
19/02/2009 11:46:59 TRIGGER
19/02/2009 11:46:59 VIEW
19/02/2009 11:46:59 PACKAGE
19/02/2009 11:46:59 PACKAGE BODY
19/02/2009 11:46:59 TYPE
19/02/2009 11:46:59 TYPE BODY
19/02/2009 11:46:59 FUNCTION
19/02/2009 11:46:59 PROCEDURE
19/02/2009 11:46:59 AddMenu
19/02/2009 11:46:59 AddMenu Differences
19/02/2009 11:46:59 TRIGGER
19/02/2009 11:46:59 VIEW
19/02/2009 11:46:59 PACKAGE
19/02/2009 11:46:59 PACKAGE BODY
19/02/2009 11:46:59 TYPE
19/02/2009 11:46:59 TYPE BODY
19/02/2009 11:46:59 FUNCTION
19/02/2009 11:46:59 PROCEDURE
19/02/2009 11:46:59 AddMenu
19/02/2009 11:46:59 AddMenu History
19/02/2009 11:46:59 TRIGGER
19/02/2009 11:46:59 AddPlugInPopups End
19/02/2009 11:47:06 TOracleQuery $02D2C1B0 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner = 'ADDR2006R10QA'
and po.object_name = 'C_FORCE_PARCL_SINGLE_TO_CHUTES'
and po.object_type = 'PROCEDURE'
:OBJECT_OWNER = ADDR2006R10QA
:OBJECT_NAME = C_FORCE_PARCL_SINGLE_TO_CHUTES
:OBJECT_TYPE = PROCEDURE
19/02/2009 11:47:06 TOracleQuery $02D2C1B0 End (1 record processed)
Duration = 0
19/02/2009 11:47:06 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = --
-- you must have granted select on sys.v_$db_object_cache
--
select decode(kept,'YES','UnKeep','Keep') caption
from sys.v_$db_object_cache
where owner like 'ADDR2006R10QA'
and name like 'C_FORCE_PARCL_SINGLE_TO_CHUTES'
and type like 'PROCEDURE'
union
select 'Keep' caption from dual
order by 1 desc
19/02/2009 11:47:08 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 2.562
19/02/2009 11:47:08 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select status
from sys.all_objects
where owner = 'ADDR2006R10QA'
and object_name ='C_FORCE_PARCL_SINGLE_TO_CHUTES'
19/02/2009 11:47:08 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0.016
19/02/2009 11:47:08 AddPlugInPopups Start 3
19/02/2009 11:47:08 Active Query Builder
19/02/2009 11:47:08 Browser Extender version 2.0 by Joachim Rupik
19/02/2009 11:47:08 Index
19/02/2009 11:47:08 Table
19/02/2009 11:47:08 User
19/02/2009 11:47:08 Tablespace
19/02/2009 11:47:08 Function
19/02/2009 11:47:08 Package
19/02/2009 11:47:08 Package body
19/02/2009 11:47:08 PROCEDURE
19/02/2009 11:47:08 AddMenu
19/02/2009 11:47:08 AddMenu Keep
19/02/2009 11:47:08 Sequence
19/02/2009 11:47:08 Trigger
19/02/2009 11:47:08 Type
19/02/2009 11:47:08 Type body
19/02/2009 11:47:08 Database link
19/02/2009 11:47:08 Directory
19/02/2009 11:47:08 Foreign Key
19/02/2009 11:47:08 Function
19/02/2009 11:47:08 Index
19/02/2009 11:47:08 Package
19/02/2009 11:47:08 Package body
19/02/2009 11:47:08 Primary Key
19/02/2009 11:47:08 PROCEDURE
19/02/2009 11:47:08 AddMenu
19/02/2009 11:47:08 AddMenu >>> VALID <<<
19/02/2009 11:47:08 Sequence
19/02/2009 11:47:08 Synonym
19/02/2009 11:47:08 Table
19/02/2009 11:47:09 Trigger
19/02/2009 11:47:09 Unique Key
19/02/2009 11:47:09 View
19/02/2009 11:47:09 Table
19/02/2009 11:47:09 Table
19/02/2009 11:47:09 Table
19/02/2009 11:47:09 Version Control Interface 1.2
19/02/2009 11:47:09 ProcedureWindow
19/02/2009 11:47:09 SQLWindow
19/02/2009 11:47:09 TestWindow
19/02/2009 11:47:09 CommandWindow
19/02/2009 11:47:09 ProcedureWindow
19/02/2009 11:47:09 SQLWindow
19/02/2009 11:47:09 TestWindow
19/02/2009 11:47:09 CommandWindow
19/02/2009 11:47:09 ProcedureWindow
19/02/2009 11:47:09 SQLWindow
19/02/2009 11:47:09 TestWindow
19/02/2009 11:47:09 CommandWindow
19/02/2009 11:47:09 ProcedureWindow
19/02/2009 11:47:09 SQLWindow
19/02/2009 11:47:09 TestWindow
19/02/2009 11:47:09 CommandWindow
19/02/2009 11:47:09 ProcedureWindow
19/02/2009 11:47:09 SQLWindow
19/02/2009 11:47:09 TestWindow
19/02/2009 11:47:09 CommandWindow
19/02/2009 11:47:09 ProcedureWindow
19/02/2009 11:47:09 SQLWindow
19/02/2009 11:47:09 TestWindow
19/02/2009 11:47:09 CommandWindow
19/02/2009 11:47:09 VIEW
19/02/2009 11:47:09 PACKAGE
19/02/2009 11:47:09 PACKAGE BODY
19/02/2009 11:47:09 TYPE
19/02/2009 11:47:09 TYPE BODY
19/02/2009 11:47:09 FUNCTION
19/02/2009 11:47:09 PROCEDURE
19/02/2009 11:47:09 AddMenu
19/02/2009 11:47:09 AddMenu -
19/02/2009 11:47:09 TRIGGER
19/02/2009 11:47:09 VIEW+
19/02/2009 11:47:09 PACKAGE+
19/02/2009 11:47:09 PACKAGE BODY+
19/02/2009 11:47:09 TYPE+
19/02/2009 11:47:09 TYPE BODY+
19/02/2009 11:47:09 FUNCTION+
19/02/2009 11:47:09 PROCEDURE+
19/02/2009 11:47:09 AddMenu
19/02/2009 11:47:09 AddMenu Check Out
19/02/2009 11:47:09 TRIGGER+
19/02/2009 11:47:09 VIEW+
19/02/2009 11:47:09 PACKAGE+
19/02/2009 11:47:09 PACKAGE BODY+
19/02/2009 11:47:09 TYPE+
19/02/2009 11:47:09 TYPE BODY+
19/02/2009 11:47:09 FUNCTION+
19/02/2009 11:47:09 PROCEDURE+
19/02/2009 11:47:09 AddMenu
19/02/2009 11:47:09 AddMenu Check In
19/02/2009 11:47:09 TRIGGER+
19/02/2009 11:47:09 VIEW+
19/02/2009 11:47:09 PACKAGE+
19/02/2009 11:47:09 PACKAGE BODY+
19/02/2009 11:47:09 TYPE+
19/02/2009 11:47:09 TYPE BODY+
19/02/2009 11:47:09 FUNCTION+
19/02/2009 11:47:09 PROCEDURE+
19/02/2009 11:47:09 AddMenu
19/02/2009 11:47:09 AddMenu Undo Check Out
19/02/2009 11:47:09 TRIGGER+
19/02/2009 11:47:09 VIEW+
19/02/2009 11:47:09 PACKAGE+
19/02/2009 11:47:09 PACKAGE BODY+
19/02/2009 11:47:09 TYPE+
19/02/2009 11:47:09 TYPE BODY+
19/02/2009 11:47:09 FUNCTION+
19/02/2009 11:47:09 PROCEDURE+
19/02/2009 11:47:09 AddMenu
19/02/2009 11:47:09 AddMenu Get from VCS
19/02/2009 11:47:09 TRIGGER+
19/02/2009 11:47:09 VIEW+
19/02/2009 11:47:09 PACKAGE+
19/02/2009 11:47:09 PACKAGE BODY+
19/02/2009 11:47:09 TYPE+
19/02/2009 11:47:09 TYPE BODY+
19/02/2009 11:47:09 FUNCTION+
19/02/2009 11:47:09 PROCEDURE+
19/02/2009 11:47:09 AddMenu
19/02/2009 11:47:09 AddMenu Add to VCS
19/02/2009 11:47:09 TRIGGER+
19/02/2009 11:47:09 VIEW
19/02/2009 11:47:09 PACKAGE
19/02/2009 11:47:09 PACKAGE BODY
19/02/2009 11:47:09 TYPE
19/02/2009 11:47:09 TYPE BODY
19/02/2009 11:47:09 FUNCTION
19/02/2009 11:47:09 PROCEDURE
19/02/2009 11:47:09 AddMenu
19/02/2009 11:47:09 AddMenu Properties
19/02/2009 11:47:09 TRIGGER
19/02/2009 11:47:09 VIEW
19/02/2009 11:47:09 PACKAGE
19/02/2009 11:47:09 PACKAGE BODY
19/02/2009 11:47:09 TYPE
19/02/2009 11:47:09 TYPE BODY
19/02/2009 11:47:09 FUNCTION
19/02/2009 11:47:09 PROCEDURE
19/02/2009 11:47:09 AddMenu
19/02/2009 11:47:09 AddMenu Differences
19/02/2009 11:47:09 TRIGGER
19/02/2009 11:47:09 VIEW
19/02/2009 11:47:09 PACKAGE
19/02/2009 11:47:09 PACKAGE BODY
19/02/2009 11:47:09 TYPE
19/02/2009 11:47:09 TYPE BODY
19/02/2009 11:47:09 FUNCTION
19/02/2009 11:47:09 PROCEDURE
19/02/2009 11:47:09 AddMenu
19/02/2009 11:47:09 AddMenu History
19/02/2009 11:47:09 TRIGGER
19/02/2009 11:47:09 AddPlugInPopups End
19/02/2009 11:47:12 TOracleQuery $02D2C730 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner = 'ADDR2006R10QA'
and po.object_name = 'C_FORCE_PARCL_SINGLE_TO_CHUTES'
and po.object_type = 'PROCEDURE'
:OBJECT_OWNER = ADDR2006R10QA
:OBJECT_NAME = C_FORCE_PARCL_SINGLE_TO_CHUTES
:OBJECT_TYPE = PROCEDURE
19/02/2009 11:47:12 TOracleQuery $02D2C730 End (1 record processed)
Duration = 0
19/02/2009 11:47:12 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = --
-- you must have granted select on sys.v_$db_object_cache
--
select decode(kept,'YES','UnKeep','Keep') caption
from sys.v_$db_object_cache
where owner like 'ADDR2006R10QA'
and name like 'C_FORCE_PARCL_SINGLE_TO_CHUTES'
and type like 'PROCEDURE'
union
select 'Keep' caption from dual
order by 1 desc
19/02/2009 11:47:15 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 2.516
19/02/2009 11:47:15 TOracleQuery PLSQLDevForm.PlugInQuery Start Query.Execute
SQL = select status
from sys.all_objects
where owner = 'ADDR2006R10QA'
and object_name ='C_FORCE_PARCL_SINGLE_TO_CHUTES'
19/02/2009 11:47:15 TOracleQuery PLSQLDevForm.PlugInQuery End (1 record processed)
Duration = 0
19/02/2009 11:47:15 AddPlugInPopups Start 3
19/02/2009 11:47:15 Active Query Builder
19/02/2009 11:47:15 Browser Extender version 2.0 by Joachim Rupik
19/02/2009 11:47:15 Index
19/02/2009 11:47:15 Table
19/02/2009 11:47:15 User
19/02/2009 11:47:15 Tablespace
19/02/2009 11:47:15 Function
19/02/2009 11:47:15 Package
19/02/2009 11:47:15 Package body
19/02/2009 11:47:15 PROCEDURE
19/02/2009 11:47:15 AddMenu
19/02/2009 11:47:15 AddMenu Keep
19/02/2009 11:47:15 Sequence
19/02/2009 11:47:15 Trigger
19/02/2009 11:47:15 Type
19/02/2009 11:47:15 Type body
19/02/2009 11:47:15 Database link
19/02/2009 11:47:15 Directory
19/02/2009 11:47:15 Foreign Key
19/02/2009 11:47:15 Function
19/02/2009 11:47:15 Index
19/02/2009 11:47:15 Package
19/02/2009 11:47:15 Package body
19/02/2009 11:47:15 Primary Key
19/02/2009 11:47:15 PROCEDURE
19/02/2009 11:47:15 AddMenu
19/02/2009 11:47:15 AddMenu >>> VALID <<<
19/02/2009 11:47:15 Sequence
19/02/2009 11:47:15 Synonym
19/02/2009 11:47:15 Table
19/02/2009 11:47:15 Trigger
19/02/2009 11:47:15 Unique Key
19/02/2009 11:47:15 View
19/02/2009 11:47:15 Table
19/02/2009 11:47:15 Table
19/02/2009 11:47:15 Table
19/02/2009 11:47:15 Version Control Interface 1.2
19/02/2009 11:47:15 ProcedureWindow
19/02/2009 11:47:15 SQLWindow
19/02/2009 11:47:15 TestWindow
19/02/2009 11:47:15 CommandWindow
19/02/2009 11:47:15 ProcedureWindow
19/02/2009 11:47:15 SQLWindow
19/02/2009 11:47:15 TestWindow
19/02/2009 11:47:15 CommandWindow
19/02/2009 11:47:15 ProcedureWindow
19/02/2009 11:47:15 SQLWindow
19/02/2009 11:47:15 TestWindow
19/02/2009 11:47:15 CommandWindow
19/02/2009 11:47:15 ProcedureWindow
19/02/2009 11:47:15 SQLWindow
19/02/2009 11:47:15 TestWindow
19/02/2009 11:47:15 CommandWindow
19/02/2009 11:47:15 ProcedureWindow
19/02/2009 11:47:15 SQLWindow
19/02/2009 11:47:15 TestWindow
19/02/2009 11:47:15 CommandWindow
19/02/2009 11:47:15 ProcedureWindow
19/02/2009 11:47:15 SQLWindow
19/02/2009 11:47:15 TestWindow
19/02/2009 11:47:15 CommandWindow
19/02/2009 11:47:15 VIEW
19/02/2009 11:47:15 PACKAGE
19/02/2009 11:47:15 PACKAGE BODY
19/02/2009 11:47:15 TYPE
19/02/2009 11:47:15 TYPE BODY
19/02/2009 11:47:15 FUNCTION
19/02/2009 11:47:15 PROCEDURE
19/02/2009 11:47:15 AddMenu
19/02/2009 11:47:15 AddMenu -
19/02/2009 11:47:15 TRIGGER
19/02/2009 11:47:15 VIEW+
19/02/2009 11:47:15 PACKAGE+
19/02/2009 11:47:15 PACKAGE BODY+
19/02/2009 11:47:15 TYPE+
19/02/2009 11:47:15 TYPE BODY+
19/02/2009 11:47:15 FUNCTION+
19/02/2009 11:47:15 PROCEDURE+
19/02/2009 11:47:15 AddMenu
19/02/2009 11:47:15 AddMenu Check Out
19/02/2009 11:47:15 TRIGGER+
19/02/2009 11:47:15 VIEW+
19/02/2009 11:47:15 PACKAGE+
19/02/2009 11:47:15 PACKAGE BODY+
19/02/2009 11:47:15 TYPE+
19/02/2009 11:47:15 TYPE BODY+
19/02/2009 11:47:15 FUNCTION+
19/02/2009 11:47:15 PROCEDURE+
19/02/2009 11:47:15 AddMenu
19/02/2009 11:47:15 AddMenu Check In
19/02/2009 11:47:15 TRIGGER+
19/02/2009 11:47:15 VIEW+
19/02/2009 11:47:15 PACKAGE+
19/02/2009 11:47:15 PACKAGE BODY+
19/02/2009 11:47:15 TYPE+
19/02/2009 11:47:15 TYPE BODY+
19/02/2009 11:47:15 FUNCTION+
19/02/2009 11:47:15 PROCEDURE+
19/02/2009 11:47:15 AddMenu
19/02/2009 11:47:15 AddMenu Undo Check Out
19/02/2009 11:47:15 TRIGGER+
19/02/2009 11:47:15 VIEW+
19/02/2009 11:47:15 PACKAGE+
19/02/2009 11:47:15 PACKAGE BODY+
19/02/2009 11:47:15 TYPE+
19/02/2009 11:47:15 TYPE BODY+
19/02/2009 11:47:15 FUNCTION+
19/02/2009 11:47:15 PROCEDURE+
19/02/2009 11:47:15 AddMenu
19/02/2009 11:47:15 AddMenu Get from VCS
19/02/2009 11:47:15 TRIGGER+
19/02/2009 11:47:15 VIEW+
19/02/2009 11:47:15 PACKAGE+
19/02/2009 11:47:15 PACKAGE BODY+
19/02/2009 11:47:15 TYPE+
19/02/2009 11:47:15 TYPE BODY+
19/02/2009 11:47:15 FUNCTION+
19/02/2009 11:47:15 PROCEDURE+
19/02/2009 11:47:15 AddMenu
19/02/2009 11:47:15 AddMenu Add to VCS
19/02/2009 11:47:16 TRIGGER+
19/02/2009 11:47:16 VIEW
19/02/2009 11:47:16 PACKAGE
19/02/2009 11:47:16 PACKAGE BODY
19/02/2009 11:47:16 TYPE
19/02/2009 11:47:16 TYPE BODY
19/02/2009 11:47:16 FUNCTION
19/02/2009 11:47:16 PROCEDURE
19/02/2009 11:47:16 AddMenu
19/02/2009 11:47:16 AddMenu Properties
19/02/2009 11:47:16 TRIGGER
19/02/2009 11:47:16 VIEW
19/02/2009 11:47:16 PACKAGE
19/02/2009 11:47:16 PACKAGE BODY
19/02/2009 11:47:16 TYPE
19/02/2009 11:47:16 TYPE BODY
19/02/2009 11:47:16 FUNCTION
19/02/2009 11:47:16 PROCEDURE
19/02/2009 11:47:16 AddMenu
19/02/2009 11:47:16 AddMenu Differences
19/02/2009 11:47:16 TRIGGER
19/02/2009 11:47:16 VIEW
19/02/2009 11:47:16 PACKAGE
19/02/2009 11:47:16 PACKAGE BODY
19/02/2009 11:47:16 TYPE
19/02/2009 11:47:16 TYPE BODY
19/02/2009 11:47:16 FUNCTION
19/02/2009 11:47:16 PROCEDURE
19/02/2009 11:47:16 AddMenu
19/02/2009 11:47:16 AddMenu History
19/02/2009 11:47:16 TRIGGER
19/02/2009 11:47:16 AddPlugInPopups End

Re: PL/SQL developer hangs upon Right clicking on Procedure, package, function
iratta #33403 02/19/09 10:58 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
As a test, can you modify the shortcut and add the noplugins parameter and try again? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" noplugins

Let me know if this helps.


Marco Kalter
Allround Automations
Re: PL/SQL developer hangs upon Right clicking on Procedure, package, function
Marco Kalter #33448 02/25/09 10:44 AM
Joined: Jan 2008
Posts: 11
I
iratta Offline OP
Member
OP Offline
Member
I
Joined: Jan 2008
Posts: 11
Without the Plugins, the program is faster now. Thank you Marco


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.031s Queries: 13 (0.010s) Memory: 2.5925 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-12 22:37:25 UTC
Valid HTML 5 and Valid CSS