Debug/Test V7 and V8 don't work with Oracle 11.1.0.7 .0

M

mariopao

Member
I try to execute a store procedure pl/sql in a windows test in debug mode but doesn't work.
My DB is 11.1.0.7 .0, I tried with oracle 10 an 11 client but each time I start a debug session I met a problem. Some time plsql/developer start the debug session but is impossible show the statment in execution, sometime it works but when I stop debug with shift/esc the plsql/developer is frozen until I kill the winwdos process.
Somebody else works with plsql/developer on Oracle 11.1.0.7.0 without this problem?
 
Last edited:
We have done several tests on 11.1.0.7.0, but it seems to work fine.

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.
 
Following my Log file :
PL/SQL Developer
Version 7.1.5.1398
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

Physical memory : 2.095.600 kB (1.281.484 available)
Paging file : 4.037.608 kB (3.452.584 available)
Virtual memory : 2.097.024 kB (2.020.568 available)

Parameters
C:\Programmi\PLSQL Developer\plsqldev.exe
debugsql

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

Preference Files

Plug-Ins

10/09/2009 15.36.54 Application started
10/09/2009 15.36.54 InitPreferences
10/09/2009 15.36.54 Load C:\Programmi\PLSQL Developer\Preferences\Default = 0
10/09/2009 15.36.54 PreferenceSet.Load C:\Programmi\PLSQL Developer\Preferences\Default\Default.ini
10/09/2009 15.36.54 PreferenceSet.Load OK
10/09/2009 15.36.54 Determine LocalPrefPath
10/09/2009 15.36.54 [1]: C:\Programmi\PLSQL Developer\Preferences
10/09/2009 15.36.54 LocalPrefPath: C:\Programmi\PLSQL Developer\Preferences\mpaolicchi
10/09/2009 15.36.54 Load C:\Programmi\PLSQL Developer\Preferences\mpaolicchi = 0
10/09/2009 15.36.54 PreferenceSet.Load C:\Programmi\PLSQL Developer\Preferences\mpaolicchi\default.ini
10/09/2009 15.36.54 PreferenceSet.Load OK
10/09/2009 15.36.54 PreferenceSet.Load C:\Programmi\PLSQL Developer\Preferences\mpaolicchi\user.prefs
10/09/2009 15.36.54 PreferenceSet.Load OK
10/09/2009 15.36.54 InitPreferences end
10/09/2009 15.36.54 SortPreferenceSets
10/09/2009 15.36.54 - Default mpaolicchi
10/09/2009 15.36.54 - System Default
10/09/2009 15.36.55 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
10/09/2009 15.36.55 ReadString OK
10/09/2009 15.36.55 pfReadRegistry: "C:\Programmi\PLSQL Developer\PLSQLDev.exe" "%1"
10/09/2009 15.36.55 LoadPreferences
10/09/2009 15.36.55 LoadPreferences searching for default
10/09/2009 15.36.55 C:\Programmi\PLSQL Developer\Preferences\mpaolicchi\default.ini
10/09/2009 15.36.55 LoadPreferences NewPref := nil
10/09/2009 15.36.55 LoadPreferences
10/09/2009 15.36.55 LoadPreferences Reading preferences
10/09/2009 15.36.55 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
10/09/2009 15.36.55 ReadString OK
10/09/2009 15.36.55 pfReadRegistry: "C:\Programmi\PLSQL Developer\PLSQLDev.exe" "%1"
10/09/2009 15.36.55 LoadPreferences ReadPosition
10/09/2009 15.36.55 LoadPreferences ToolsBrowserItemClick(nil)
10/09/2009 15.36.55 LoadPreferences CreateBrowserFilters...
10/09/2009 15.36.55 LoadPreferences Files
10/09/2009 15.36.55 LoadPreferences Logon
10/09/2009 15.36.55 LoadPreferences Buttons
10/09/2009 15.36.55 LoadPreferences Printer
10/09/2009 15.36.55 LoadPreferences BrowserFolders
10/09/2009 15.36.55 LoadPreferences
10/09/2009 15.36.55 LoadPreferences end
10/09/2009 15.36.55 MacroLibFilename: C:\Programmi\PLSQL Developer\Macro\mpaolicchi.lib
10/09/2009 15.37.01 TOracleSession PLSQLDevForm.Session Start Session.LogOn as kuwait@CPROMSV
10/09/2009 15.37.02 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
10/09/2009 15.37.02 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0,09
10/09/2009 15.37.02 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
10/09/2009 15.37.02 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0,06
10/09/2009 15.37.02 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
10/09/2009 15.37.02 TOracleQuery Query End (1 record processed)
Duration = 0,06
10/09/2009 15.37.02 TOracleSession PLSQLDevForm.Session End
Duration = 0,891
10/09/2009 15.37.02 LogonHistorySave start
10/09/2009 15.37.02 ChangeUserPref LogonHistory,
10/09/2009 15.37.02 ChangeUserPref DSA,
10/09/2009 15.37.02 ChangeUserPref end
10/09/2009 15.37.02 ChangeUserPref ColumnAssociations,
10/09/2009 15.37.02 ChangeUserPref end
10/09/2009 15.37.02 ChangeUserPref ImportAssociations,
10/09/2009 15.37.02 ChangeUserPref end
10/09/2009 15.37.02 ChangeUserPref BrowserFilters,
10/09/2009 15.37.02 ChangeUserPref end
10/09/2009 15.37.02 ChangeUserPref BrowserFolders,
10/09/2009 15.37.02 ChangeUserPref end
10/09/2009 15.37.02 ChangeUserPref SessionQueries,
10/09/2009 15.37.02 ChangeUserPref end
10/09/2009 15.37.02 ChangeUserPref ExternalTools,
10/09/2009 15.37.02 ChangeUserPref end
10/09/2009 15.37.02 ChangeUserPref Documents,
10/09/2009 15.37.02 ChangeUserPref end
10/09/2009 15.37.02 ChangeUserPref Reports,
10/09/2009 15.37.02 ChangeUserPref end
10/09/2009 15.37.02 LogonHistorySave end
10/09/2009 15.37.02 FormCreate Session.Connected
10/09/2009 15.37.02 FormCreate Logon.Executed -1
10/09/2009 15.37.02 FormCreate TDBNames.Make
10/09/2009 15.37.02 FormCreate SessionChanged
10/09/2009 15.37.02 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
10/09/2009 15.37.02 TOracleQuery Query End (5 records processed)
Duration = 0,06
10/09/2009 15.37.02 SessionChanged SetDBAViews
10/09/2009 15.37.02 TOracleQuery $02A28850 Start Query.Execute
SQL = select null from all_synonyms where 1=0
10/09/2009 15.37.02 TOracleQuery $02A28850 End (0 records processed)
Duration = 0,08
10/09/2009 15.37.02 TOracleQuery $02A28850 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
10/09/2009 15.37.02 TOracleQuery $02A28850 End (0 records processed)
Duration = 0,071
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,08
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,04
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,04
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,05
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,04
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,04
10/09/2009 15.37.02 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,04
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,04
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,04
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,04
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,05
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,04
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,04
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
10/09/2009 15.37.03 TOracleQuery PLSQLDevForm.DynamicQuery End (37 records processed)
Duration = 0,04
10/09/2009 15.37.03 TOracleQuery $02A28850 Start Query.Describe
SQL = select * from sys.dba_objects where rownum < 1
10/09/2009 15.37.03 TOracleQuery $02A28850 End
Duration = 0,04
10/09/2009 15.37.03 TOracleQuery $02A28850 Start Query.Describe
SQL = select * from sys.dba_tab_columns where rownum < 1
10/09/2009 15.37.03 TOracleQuery $02A28850 End
Duration = 0,05
10/09/2009 15.37.03 TOracleQuery $02A28850 Start Query.Describe
SQL = select * from sys.dba_col_comments where rownum < 1
10/09/2009 15.37.03 TOracleQuery $02A28850 End
Duration = 0,03
10/09/2009 15.37.03 TOracleQuery $02A28850 Start Query.Describe
SQL = select * from sys.dba_triggers where rownum < 1
10/09/2009 15.37.03 TOracleQuery $02A28850 End
Duration = 0,04
10/09/2009 15.37.03 TOracleQuery $02A28850 Start Query.Describe
SQL = select * from sys.dba_constraints where rownum < 1
10/09/2009 15.37.03 TOracleQuery $02A28850 End
Duration = 0,05
10/09/2009 15.37.03 TOracleQuery $02A28850 Start Query.Describe
SQL = select * from sys.dba_indexes where rownum < 1
10/09/2009 15.37.03 TOracleQuery $02A28850 End
Duration = 0,06
10/09/2009 15.37.03 TOracleQuery $02A28850 Start Query.Describe
SQL = select * from sys.dba_cons_columns where rownum < 1
10/09/2009 15.37.03 TOracleQuery $02A28850 End
Duration = 0,03
10/09/2009 15.37.03 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_ind_columns where rownum < 1
10/09/2009 15.37.03 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.03 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_dependencies where rownum < 1
10/09/2009 15.37.03 TOracleQuery $02A282D0 End
Duration = 0,03
10/09/2009 15.37.03 TOracleQuery $02A28850 Start Query.Describe
SQL = select * from sys.dba_tables where rownum < 1
10/09/2009 15.37.03 TOracleQuery $02A28850 End
Duration = 0,05
10/09/2009 15.37.03 TOracleQuery $02A28850 Start Query.Describe
SQL = select * from sys.dba_tab_comments where rownum < 1
10/09/2009 15.37.03 TOracleQuery $02A28850 End
Duration = 0,031
10/09/2009 15.37.04 TOracleQuery $02A28850 Start Query.Describe
SQL = select * from sys.dba_sequences where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A28850 End
Duration = 0,04
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_errors where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_source where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,03
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_views where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,03
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_synonyms where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_users where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_object_tables where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,05
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_type_attrs where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_type_methods where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_method_params where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_method_results where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,03
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_tab_privs where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,03
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_clusters where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,051
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_libraries where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_directories where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_jobs where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_db_links where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_mviews where rownum < 1
10/09/2009 15.37.04 TOracleQuery $02A282D0 End
Duration = 0,05
10/09/2009 15.37.04 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_snapshots where rownum < 1
10/09/2009 15.37.05 TOracleQuery $02A282D0 End
Duration = 0,05
10/09/2009 15.37.05 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_queues where rownum < 1
10/09/2009 15.37.05 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.05 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_queue_tables where rownum < 1
10/09/2009 15.37.05 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.05 TOracleQuery $02A282D0 Start Query.Describe
SQL = select * from sys.dba_types where rownum < 1
10/09/2009 15.37.05 TOracleQuery $02A282D0 End
Duration = 0,04
10/09/2009 15.37.05 SessionChanged Authorizations.Load
10/09/2009 15.37.05 TOracleQuery $02A282D0 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)
10/09/2009 15.37.05 TOracleQuery $02A282D0 End
Result = ORA-00942: tabella o vista inesistente
Duration = 0,09
10/09/2009 15.37.05 SessionChanged EnableAuthorizedMenus
10/09/2009 15.37.05 TOracleSession $0332A6B0 Start Session.LogOn as kuwait@CPROMSV
10/09/2009 15.37.05 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
10/09/2009 15.37.05 TOracleQuery Query End (1 record processed)
Duration = 0,07
10/09/2009 15.37.05 TOracleSession $0332A6B0 End
Duration = 0,461
10/09/2009 15.37.05 SetSessionAction starts: Main session
10/09/2009 15.37.05 TOracleQuery $02A28590 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')
10/09/2009 15.37.05 TOracleQuery $02A28850 Start Query.Execute
SQL = select null from dual
10/09/2009 15.37.05 TOracleQuery $02A28850 End (1 record processed)
Duration = 0,06
10/09/2009 15.37.05 TOracleQuery $02A28850 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
10/09/2009 15.37.05 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,1
10/09/2009 15.37.05 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.05 TOracleQuery $02A28850 End
Duration = 0,04
10/09/2009 15.37.05 SetSessionAction ends
10/09/2009 15.37.05 ExecuteConnectScript starts
10/09/2009 15.37.06 ExecuteConnectScript ends
10/09/2009 15.37.06 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
10/09/2009 15.37.06 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.06 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.06 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0,061
10/09/2009 15.37.06 SessionChanged LoadRecentObjects
10/09/2009 15.37.06 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,051
10/09/2009 15.37.06 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.06 SessionChanged Notify children
10/09/2009 15.37.06 SessionChanged Logoff secondary sessions
10/09/2009 15.37.06 SessionChanged SessionMode = smMulti
10/09/2009 15.37.06 SessionChanged EnableChildFunctions
10/09/2009 15.37.06 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.06 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.06 TOracleQuery $02A28590 End (21 records processed)
Duration = 0,03
10/09/2009 15.37.06 TOracleQuery $02A28590 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')
10/09/2009 15.37.06 SessionChanged
OCIDLL forced to C:\oracle\product\11.1.0\client_1\bin\oci.dll
10/09/2009 15.37.06 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
10/09/2009 15.37.06 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0,08
10/09/2009 15.37.06 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,28
10/09/2009 15.37.06 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.06 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.06 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.06 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.06 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.06 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.06 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.06 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,051
10/09/2009 15.37.06 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.06 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.06 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.06 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.06 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.06 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.06 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,061
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,07
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,07
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.07 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,08
10/09/2009 15.37.07 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.08 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.08 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.08 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,08
10/09/2009 15.37.08 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.08 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.08 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.08 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.08 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.08 SortPreferenceSets
10/09/2009 15.37.08 - Default mpaolicchi
10/09/2009 15.37.08 - System Default
10/09/2009 15.37.08 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,1
10/09/2009 15.37.08 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.08 TOracleQuery $02A27EB0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
10/09/2009 15.37.08 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,05
10/09/2009 15.37.08 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.08 TOracleQuery $02A27EB0 End (0 records processed)
Duration = 0,07
10/09/2009 15.37.08 TOracleQuery $02A27EB0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
10/09/2009 15.37.08 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.08 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.08 TOracleQuery $02A27EB0 End (0 records processed)
Duration = 0,06
10/09/2009 15.37.08 WMUpdatePopups starts
10/09/2009 15.37.08 LoadDesktop starts
10/09/2009 15.37.08 LoadDesktop ends
10/09/2009 15.37.08 WMUpdatePopups ends
10/09/2009 15.37.08 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,16
10/09/2009 15.37.08 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.08 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,081
10/09/2009 15.37.08 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.11 TOracleQuery $02A28590 End (100 records processed)
Duration = 2,563
10/09/2009 15.37.11 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.11 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,14
10/09/2009 15.37.11 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.11 TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Execute
SQL = select object_name, owner object_owner, status, object_type, created, last_ddl_time
from sys.dba_objects o
where object_type = 'PACKAGE'
and object_name not like 'BIN$%'

and (owner = user)
order by decode(owner, user, 0, 1),
owner,
object_name
:OBJECT_TYPE = PACKAGE
:EXTRA_CONDITION =
10/09/2009 15.37.11 TOracleQuery PLSQLDevForm.ObjectQuery End (9 records processed)
Duration = 0,08
10/09/2009 15.37.11 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,231
10/09/2009 15.37.11 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.12 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,26
10/09/2009 15.37.12 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.12 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,07
10/09/2009 15.37.12 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.12 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.12 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.12 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,141
10/09/2009 15.37.12 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.12 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,07
10/09/2009 15.37.12 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.12 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.12 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.12 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,11
10/09/2009 15.37.12 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.12 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,11
10/09/2009 15.37.12 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.12 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,11
10/09/2009 15.37.12 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.13 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.13 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.13 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,12
10/09/2009 15.37.13 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.13 TOracleQuery $02A28590 End (100 records processed)
Duration = 0,15
10/09/2009 15.37.13 TOracleQuery $02A28590 Start Query.Next for up to 100 records
10/09/2009 15.37.13 TOracleQuery $02A28590 End (23 records processed)
Duration = 0,08
10/09/2009 15.37.13 TOracleSession $0332A6B0 Start Session.LogOff
10/09/2009 15.37.13 TOracleSession $0332A6B0 End
Duration = 0,02
10/09/2009 15.37.15 TOracleQuery $02A27EB0 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner = 'KUWAIT'
and po.object_name = 'DWH_BONUS_COMPLEANNO'
and po.object_type = 'PACKAGE'
:OBJECT_OWNER = KUWAIT
:OBJECT_NAME = DWH_BONUS_COMPLEANNO
:OBJECT_TYPE = PACKAGE
10/09/2009 15.37.15 TOracleQuery $02A27EB0 End (1 record processed)
Duration = 0,13
10/09/2009 15.37.15 AddPlugInPopups Start 0
10/09/2009 15.37.15 AddPlugInPopups End
10/09/2009 15.37.19 Create TProcEditForm Start
10/09/2009 15.37.19 Create TProcEditForm Inherited
10/09/2009 15.37.20 Create TProcEditForm SetupMainFont
10/09/2009 15.37.20 Create TProcEditForm Activate
10/09/2009 15.37.20 Create TProcEditForm Activate done
10/09/2009 15.37.20 Create TProcEditForm UpdateWindowList
10/09/2009 15.37.20 Create TProcEditForm Positioning
10/09/2009 15.37.20 Create TProcEditForm Finished
10/09/2009 15.37.20 TOracleQuery $02A28170 Start Query.Execute
SQL = select text from sys.dba_source
where owner = :owner
and name = :name
and type = :type
order by line
:OWNER = KUWAIT
:NAME = DWH_BONUS_COMPLEANNO
:TYPE = PACKAGE
10/09/2009 15.37.20 TOracleQuery $02A28170 End (20 records processed)
Duration = 0,13
10/09/2009 15.37.20 TOracleQuery PLSQLDevForm.ProgErrorQuery Start Query.Execute
SQL = select *
from sys.dba_errors
where name = :name and type = :type and owner = :owner
order by sequence
:NAME = DWH_BONUS_COMPLEANNO
:TYPE = PACKAGE
:OWNER = KUWAIT
10/09/2009 15.37.20 TOracleQuery PLSQLDevForm.ProgErrorQuery End (0 records processed)
Duration = 0,13
10/09/2009 15.37.20 ProcEditForm.GetTabNames
10/09/2009 15.37.20 + DWH_BONUS_COMPLEANNO
10/09/2009 15.37.20 ProcEditForm.GetTabNames done
10/09/2009 15.37.20 NavigationBookmarks.EnableButtons(Rebuild)
10/09/2009 15.37.20 NavigationBookmarks: Backward=0, Forward=0
10/09/2009 15.37.20 UpdateContents(Clear)
10/09/2009 15.37.20 Source = CREATE OR REPLACE PACKAGE DWH_BONUS_COMPLEANNO IS
10/09/2009 15.37.20 UpdatingContents: Thread Started
10/09/2009 15.37.20 NavigationBookmarks.EnableButtons(Rebuild)
10/09/2009 15.37.20 NavigationBookmarks: Backward=0, Forward=0
10/09/2009 15.37.20 ContentsThread: Execute
10/09/2009 15.37.20 ContentsThread: Analyze
10/09/2009 15.37.20 ContentsThread: Valid
10/09/2009 15.37.20 ContentsUpdated
10/09/2009 15.37.20 ContentsUpdated: Valid
10/09/2009 15.37.20 ContentsUpdated: Refresh Code Contents
10/09/2009 15.37.20 ContentsThread: Suspend started
10/09/2009 15.37.26 Destroying TProcEditForm
10/09/2009 15.37.26 ContentsThread: Resume
10/09/2009 15.37.26 Destroyed TProcEditForm
10/09/2009 15.37.27 TOracleQuery $02A27EB0 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner = 'KUWAIT'
and po.object_name = 'DWH_BONUS_COMPLEANNO'
and po.object_type = 'PACKAGE'
:OBJECT_OWNER = KUWAIT
:OBJECT_NAME = DWH_BONUS_COMPLEANNO
:OBJECT_TYPE = PACKAGE
10/09/2009 15.37.27 TOracleQuery $02A27EB0 End (1 record processed)
Duration = 0,14
10/09/2009 15.37.27 AddPlugInPopups Start 0
10/09/2009 15.37.27 AddPlugInPopups End
10/09/2009 15.37.29 Create TProcEditForm Start
10/09/2009 15.37.29 Create TProcEditForm Inherited
10/09/2009 15.37.29 Create TProcEditForm SetupMainFont
10/09/2009 15.37.29 Create TProcEditForm Activate
10/09/2009 15.37.29 Create TProcEditForm Activate done
10/09/2009 15.37.29 Create TProcEditForm UpdateWindowList
10/09/2009 15.37.29 Create TProcEditForm Positioning
10/09/2009 15.37.29 Create TProcEditForm Finished
10/09/2009 15.37.29 TOracleQuery $02A28170 Start Query.Execute
SQL = select text from sys.dba_source
where owner = :owner
and name = :name
and type = :type
order by line
:OWNER = KUWAIT
:NAME = DWH_BONUS_COMPLEANNO
:TYPE = PACKAGE
10/09/2009 15.37.29 TOracleQuery $02A28170 End (20 records processed)
Duration = 0,08
10/09/2009 15.37.29 TOracleQuery PLSQLDevForm.ProgErrorQuery Start Query.Execute
SQL = select *
from sys.dba_errors
where name = :name and type = :type and owner = :owner
order by sequence
:NAME = DWH_BONUS_COMPLEANNO
:TYPE = PACKAGE
:OWNER = KUWAIT
10/09/2009 15.37.29 TOracleQuery PLSQLDevForm.ProgErrorQuery End (0 records processed)
Duration = 0,121
10/09/2009 15.37.29 ProcEditForm.GetTabNames
10/09/2009 15.37.29 + DWH_BONUS_COMPLEANNO
10/09/2009 15.37.29 ProcEditForm.GetTabNames done
10/09/2009 15.37.29 NavigationBookmarks.EnableButtons(Rebuild)
10/09/2009 15.37.29 NavigationBookmarks: Backward=0, Forward=0
10/09/2009 15.37.29 UpdateContents(Clear)
10/09/2009 15.37.29 Source = CREATE OR REPLACE PACKAGE DWH_BONUS_COMPLEANNO IS
10/09/2009 15.37.29 UpdatingContents: Thread Started
10/09/2009 15.37.29 TOracleQuery $02A28170 Start Query.Execute
SQL = select * from sys.dba_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 = KUWAIT
:OBJECT_NAME = DWH_BONUS_COMPLEANNO
:SUB_OBJECT = Null
10/09/2009 15.37.29 ContentsThread: Execute
10/09/2009 15.37.29 ContentsThread: Analyze
10/09/2009 15.37.29 ContentsThread: Valid
10/09/2009 15.37.29 ContentsThread: Suspend started
10/09/2009 15.37.29 TOracleQuery $02A28170 End (1 record processed)
Duration = 0,09
10/09/2009 15.37.29 TOracleQuery $02A28170 Start Query.Execute
SQL = select text from sys.dba_source
where owner = :owner
and name = :name
and type = :type
order by line
:OWNER = KUWAIT
:NAME = DWH_BONUS_COMPLEANNO
:TYPE = PACKAGE BODY
10/09/2009 15.37.30 TOracleQuery $02A28170 End (100 records processed)
Duration = 0,23
10/09/2009 15.37.30 TOracleQuery $02A28170 Start Query.Next for up to 100 records
10/09/2009 15.37.30 TOracleQuery $02A28170 End (100 records processed)
Duration = 0,06
10/09/2009 15.37.30 TOracleQuery $02A28170 Start Query.Next for up to 100 records
10/09/2009 15.37.30 TOracleQuery $02A28170 End (100 records processed)
Duration = 0,101
10/09/2009 15.37.30 TOracleQuery $02A28170 Start Query.Next for up to 100 records
10/09/2009 15.37.30 TOracleQuery $02A28170 End (100 records processed)
Duration = 0,13
10/09/2009 15.37.30 TOracleQuery $02A28170 Start Query.Next for up to 100 records
10/09/2009 15.37.30 TOracleQuery $02A28170 End (33 records processed)
Duration = 0,1
10/09/2009 15.37.30 TOracleQuery $02A28170 Start Query.Execute
SQL = select text from sys.dba_source
where owner = :owner
and name = :name
and type = :type
order by line
:OWNER = KUWAIT
:NAME = DWH_BONUS_COMPLEANNO
:TYPE = PACKAGE BODY
10/09/2009 15.37.30 TOracleQuery $02A28170 End (100 records processed)
Duration = 0,16
10/09/2009 15.37.30 TOracleQuery $02A28170 Start Query.Next for up to 100 records
10/09/2009 15.37.30 TOracleQuery $02A28170 End (100 records processed)
Duration = 0,1
10/09/2009 15.37.30 TOracleQuery $02A28170 Start Query.Next for up to 100 records
10/09/2009 15.37.31 TOracleQuery $02A28170 End (100 records processed)
Duration = 0,111
10/09/2009 15.37.31 TOracleQuery $02A28170 Start Query.Next for up to 100 records
10/09/2009 15.37.31 TOracleQuery $02A28170 End (100 records processed)
Duration = 0,12
10/09/2009 15.37.31 TOracleQuery $02A28170 Start Query.Next for up to 100 records
10/09/2009 15.37.31 TOracleQuery $02A28170 End (33 records processed)
Duration = 0,1
10/09/2009 15.37.31 TOracleQuery PLSQLDevForm.ProgErrorQuery Start Query.Execute
SQL = select *
from sys.dba_errors
where name = :name and type = :type and owner = :owner
order by sequence
:NAME = DWH_BONUS_COMPLEANNO
:TYPE = PACKAGE BODY
:OWNER = KUWAIT
10/09/2009 15.37.31 TOracleQuery PLSQLDevForm.ProgErrorQuery End (0 records processed)
Duration = 0,13
10/09/2009 15.37.31 ProcEditForm.GetTabNames
10/09/2009 15.37.31 + DWH_BONUS_COMPLEANNO
10/09/2009 15.37.31 + DWH_BONUS_COMPLEANNO
10/09/2009 15.37.31 ProcEditForm.GetTabNames done
10/09/2009 15.37.31 NavigationBookmarks.EnableButtons(Rebuild)
10/09/2009 15.37.31 NavigationBookmarks: Backward=0, Forward=0
10/09/2009 15.37.31 UpdateContents(Clear)
10/09/2009 15.37.31 Source = CREATE OR REPLACE PACKAGE BODY DWH_BONUS_COMPLEANNO IS
10/09/2009 15.37.31 ContentsThread: Resume
10/09/2009 15.37.31 UpdatingContents: Thread Started
10/09/2009 15.37.31 NavigationBookmarks.EnableButtons(Rebuild)
10/09/2009 15.37.31 NavigationBookmarks: Backward=0, Forward=0
10/09/2009 15.37.31 UpdateContents(Clear)
10/09/2009 15.37.31 Source = CREATE OR REPLACE PACKAGE DWH_BONUS_COMPLEANNO IS
10/09/2009 15.37.31 ContentsThread: Analyze
10/09/2009 15.37.31 ContentsThread: Valid
10/09/2009 15.37.31 ContentsThread: Suspend started
10/09/2009 15.37.31 ContentsThread: Resume
10/09/2009 15.37.31 UpdatingContents: Thread Started
10/09/2009 15.37.31 NavigationBookmarks.EnableButtons(Rebuild)
10/09/2009 15.37.31 NavigationBookmarks: Backward=0, Forward=0
10/09/2009 15.37.31 ContentsUpdated
10/09/2009 15.37.31 ContentsUpdated: Valid
10/09/2009 15.37.31 ContentsUpdated: Refresh Code Contents
10/09/2009 15.37.31 ContentsUpdated
10/09/2009 15.37.31 ContentsUpdated: Valid
10/09/2009 15.37.31 ContentsUpdated: Refresh Code Contents
10/09/2009 15.37.31 ContentsThread: Analyze
10/09/2009 15.37.31 ContentsThread: Valid
10/09/2009 15.37.31 ContentsThread: Suspend started
10/09/2009 15.37.31 ContentsUpdated
10/09/2009 15.37.31 ContentsUpdated: Valid
10/09/2009 15.37.31 ContentsUpdated: Move Code Contents
10/09/2009 15.37.33 NavigationBookmarks.EnableButtons(Rebuild)
10/09/2009 15.37.33 NavigationBookmarks: Backward=0, Forward=0
10/09/2009 15.37.33 UpdateContents(Clear)
10/09/2009 15.37.33 Source = CREATE OR REPLACE PACKAGE BODY DWH_BONUS_COMPLEANNO IS
10/09/2009 15.37.33 ContentsThread: Resume
10/09/2009 15.37.33 UpdatingContents: Thread Started
10/09/2009 15.37.33 ContentsThread: Analyze
10/09/2009 15.37.33 ContentsThread: Valid
10/09/2009 15.37.33 ContentsUpdated
10/09/2009 15.37.33 ContentsUpdated: Valid
10/09/2009 15.37.33 ContentsUpdated: Refresh Code Contents
10/09/2009 15.37.33 ContentsThread: Suspend started
10/09/2009 15.37.34 AddNavigationBookmark starts
10/09/2009 15.37.34 AddNavigationBookmark GNV00001
10/09/2009 15.37.34 NavigationBookmarks.EnableButtons(Rebuild)
10/09/2009 15.37.34 NavigationBookmarks: Backward=1, Forward=0
10/09/2009 15.37.34 AddNavigationBookmark ends
10/09/2009 15.37.34 AddNavigationBookmark starts
10/09/2009 15.37.34 AddNavigationBookmark GNV00002
10/09/2009 15.37.34 NavigationBookmarks.EnableButtons(Rebuild)
10/09/2009 15.37.34 NavigationBookmarks: Backward=2, Forward=0
10/09/2009 15.37.34 AddNavigationBookmark ends
10/09/2009 15.37.34 TOracleQuery $02A28170 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
10/09/2009 15.37.34 TOracleQuery $02A28170 End (1 record processed)
Duration = 0,08
10/09/2009 15.37.34 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.dba_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.dba_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.dba_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.dba_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 dba_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.dba_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 dba_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.dba_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.dba_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.dba_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 = KUWAIT
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
:PART2 = DWH_BONUS_COMPLEANNO
:SUB_OBJECT = Null
:PART3 = MAIN_DWH_BONUS_COMPLEANNO
:DEEP = 0
:CUR_SCHEMA = KUWAIT
10/09/2009 15.37.34 TOracleQuery PLSQLDevForm.ResolveSymbolQuery End
Duration = 0,09
10/09/2009 15.37.34 TOracleQuery $02A28170 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner = 'KUWAIT'
and po.object_name = 'DWH_BONUS_COMPLEANNO'
and po.object_type = 'PROCEDURE'
:OBJECT_OWNER = KUWAIT
:OBJECT_NAME = DWH_BONUS_COMPLEANNO
:OBJECT_TYPE = PROCEDURE
10/09/2009 15.37.34 TOracleQuery $02A28170 End (0 records processed)
Duration = 0,12
10/09/2009 15.37.34 AddPlugInPopups Start 0
10/09/2009 15.37.35 AddPlugInPopups End
10/09/2009 15.37.37 TOracleQuery $02A28170 Start Query.Execute
SQL = select * from sys.dba_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 = KUWAIT
:OBJECT_NAME = DWH_BONUS_COMPLEANNO
:SUB_OBJECT = Null
10/09/2009 15.37.37 TOracleQuery $02A28170 End (1 record processed)
Duration = 0,17
10/09/2009 15.37.37 TOracleQuery $02A28170 Start Query.Execute
SQL = select * from sys.dba_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 = KUWAIT
:OBJECT_NAME = DWH_BONUS_COMPLEANNO
:SUB_OBJECT = Null
10/09/2009 15.37.37 TOracleQuery $02A28170 End (1 record processed)
Duration = 0,13
10/09/2009 15.37.37 Create TTestForm Start
10/09/2009 15.37.37 Create TTestForm Inherited
10/09/2009 15.37.38 NavigationBookmarks.EnableButtons(Rebuild)
10/09/2009 15.37.38 NavigationBookmarks: Backward=2, Forward=0
10/09/2009 15.37.38 AddNavigationBookmark starts
10/09/2009 15.37.38 AddNavigationBookmark GNV00003
10/09/2009 15.37.38 NavigationBookmarks.EnableButtons(Rebuild)
10/09/2009 15.37.38 NavigationBookmarks: Backward=3, Forward=0
10/09/2009 15.37.38 AddNavigationBookmark ends
10/09/2009 15.37.38 Create TTestForm SetupMainFont
10/09/2009 15.37.38 Create TTestForm Activate
10/09/2009 15.37.38 Create TTestForm Activate done
10/09/2009 15.37.38 Create TTestForm UpdateWindowList
10/09/2009 15.37.38 Create TTestForm Positioning
10/09/2009 15.37.38 Create TTestForm Finished
10/09/2009 15.37.38 NavigationBookmarks.EnableButtons(Rebuild)
10/09/2009 15.37.38 NavigationBookmarks: Backward=3, Forward=0
10/09/2009 15.37.40 SetConnected starts
10/09/2009 15.37.40 SetConnected: ForceLogoff starts
10/09/2009 15.37.40 SetConnected: ForceLogoff ends
10/09/2009 15.37.40 SetConnected: Connect starts
10/09/2009 15.37.40 TOracleSession $058FB890 Start Session.LogOn as kuwait@CPROMSV
10/09/2009 15.37.41 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
10/09/2009 15.37.41 TOracleQuery Query End (1 record processed)
Duration = 0,121
10/09/2009 15.37.41 TOracleSession $058FB890 End
Duration = 0,882
10/09/2009 15.37.41 SetConnected: (Dis)connect ends
10/09/2009 15.37.41 SetSessionAction starts: Test Window - Script for procedure DWH_BONUS_COMPLEANNO.MAIN_DWH_BONUS_COMPLEANNO@CPROMSV
10/09/2009 15.37.41 TOracleQuery $033738A0 Start Query.Execute
SQL = select null from dual
10/09/2009 15.37.41 TOracleQuery $033738A0 End (1 record processed)
Duration = 0,11
10/09/2009 15.37.41 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
10/09/2009 15.37.42 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0,23
10/09/2009 15.37.42 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
10/09/2009 15.37.42 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0,12
10/09/2009 15.37.42 TOracleQuery $033738A0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Test Window - Script for procedure DWH_BONUS_COMPLEANNO.MAIN_DWH_BONUS_COMPLEANNO@CPROMSV
10/09/2009 15.37.42 TOracleQuery $033738A0 End
Duration = 0,121
10/09/2009 15.37.42 SetSessionAction ends
10/09/2009 15.37.42 ExecuteConnectScript starts
10/09/2009 15.37.42 ExecuteConnectScript ends
10/09/2009 15.37.42 TOracleQuery $033738A0 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
10/09/2009 15.37.42 TOracleQuery $033738A0 End (1 record processed)
Duration = 0,56
10/09/2009 15.37.42 InitHTPOutput starts
10/09/2009 15.37.42 TOracleQuery $033738A0 Start Query.Execute
SQL = begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
10/09/2009 15.37.42 TOracleQuery $033738A0 End
Duration = 0,081
10/09/2009 15.37.42 InitHTPOutput finished
10/09/2009 15.37.42 EnableOutput starts
10/09/2009 15.37.42 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
10/09/2009 15.37.43 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0,11
10/09/2009 15.37.43 EnableOutput done
10/09/2009 15.37.43 InitializeTargetSession starts
10/09/2009 15.37.43 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
10/09/2009 15.37.43 TOracleQuery Debugger.InitializeTargetQuery End
Duration = 0,12
10/09/2009 15.37.43 TOracleSession Debugger.Session Start Session.LogOn as kuwait@CPROMSV
10/09/2009 15.37.43 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
10/09/2009 15.37.44 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0,12
10/09/2009 15.37.44 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
10/09/2009 15.37.44 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0,231
10/09/2009 15.37.44 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
10/09/2009 15.37.44 TOracleQuery Query End (1 record processed)
Duration = 0,12
10/09/2009 15.37.44 TOracleSession Debugger.Session End
Duration = 1,232
10/09/2009 15.37.44 SetSessionAction starts: Debug Test Window - Script for procedure DWH_BONUS_COMPLEANNO.MAIN_DWH_BONUS_COMPLEANNO@CPROMSV
10/09/2009 15.37.44 TOracleQuery $033738A0 Start Query.Execute
SQL = select null from dual
10/09/2009 15.37.44 TOracleQuery $033738A0 End (1 record processed)
Duration = 0,12
10/09/2009 15.37.44 TOracleQuery $033738A0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Debug Test Window - Script for procedure DWH_BONUS_COMPLEANNO.MAIN_DWH_BONUS_COMPLEANNO@CPROMSV
10/09/2009 15.37.44 TOracleQuery $033738A0 End
Duration = 0,04
10/09/2009 15.37.44 SetSessionAction ends
10/09/2009 15.37.44 ExecuteConnectScript starts
10/09/2009 15.37.44 ExecuteConnectScript ends
10/09/2009 15.37.44 InitializeTargetSession ends
10/09/2009 15.37.44 InitStatistics starts
10/09/2009 15.37.44 TStatistics.Init starts
10/09/2009 15.37.44 InitStatNames starts
10/09/2009 15.37.44 select name from v$statname order by statistic#
10/09/2009 15.37.44 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select name from v$statname order by statistic#
10/09/2009 15.37.44 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,08
10/09/2009 15.37.44 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.44 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,09
10/09/2009 15.37.44 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.44 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,04
10/09/2009 15.37.44 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,081
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,08
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,09
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,08
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,04
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,04
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,04
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,04
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,04
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,03
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
10/09/2009 15.37.45 TOracleQuery PLSQLDevForm.DynamicQuery End (
 
You must log in or register to reply here.

Similar threads

T
  • Discussion Discussion
New PC Multiple Oracle Clients Bad Config
Replies
6
Views
2K
fabrice
F
C
  • Discussion Discussion
Check connection does not work in Multisession mode which leads to freezing app.
Replies
2
Views
1K
czdavidm
C
F
  • Discussion Discussion
32 bit PLSQL DEV , 64 bit Windows 7 and 32 bit Oracle Client
Replies
5
Views
6K
Marco Kalter
Marco Kalter
R
  • Discussion Discussion
Very slow closing all windows
Replies
8
Views
7K
Marco Kalter
Marco Kalter
S
  • Discussion Discussion
PLSQL Developer 13 - Window List issue
Replies
2
Views
2K
Sztefi
S
Back
Top