Bug, debugging function with record makes PLD to hang

Claus Pedersen

Member³
I have a package that calls a method with a record as parameter. This seems to get PLD to hang.

I have run PLD with the parameter debugsql with the content of the diagnostic file as below.

It seems that it is the following error that causes the error:
ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], []
ORA-06544: PL/SQL: internal error, arguments: [2603], [], [], [], [], [], [], []
ORA-06553: PLS-707: unsupported construct or internal error [2603]

I have debugged this package many times before, is it the database that is in a bad condition?
Code:
PL/SQL Developer
  Version 7.1.4.1391
  Windows XP Professional 5.1 Build 2600 (Service Pack 2)

  Physical memory : 2.088.380 kB  (1.088.756 available)
  Paging file     : 3.495.956 kB  (2.958.688 available)
  Virtual memory  : 2.097.024 kB  (2.023.108 available)

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

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

Preference Files

Plug-Ins

20-12-2007 13:08:16  Application started
20-12-2007 13:08:16  InitPreferences
20-12-2007 13:08:16  Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
20-12-2007 13:08:16  PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
20-12-2007 13:08:16  PreferenceSet.Load OK
20-12-2007 13:08:16  Determine LocalPrefPath
20-12-2007 13:08:16  [1]: C:\Program Files\PLSQL Developer\Preferences
20-12-2007 13:08:16  LocalPrefPath: C:\Program Files\PLSQL Developer\Preferences\CP
20-12-2007 13:08:16  Load C:\Program Files\PLSQL Developer\Preferences\CP = 0
20-12-2007 13:08:16  PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\CP\default.ini
20-12-2007 13:08:16  PreferenceSet.Load OK
20-12-2007 13:08:16  PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\CP\user.prefs
20-12-2007 13:08:16  PreferenceSet.Load OK
20-12-2007 13:08:16  InitPreferences end
20-12-2007 13:08:16  SortPreferenceSets
20-12-2007 13:08:16   - Default CP
20-12-2007 13:08:16   - System Default
20-12-2007 13:08:16  pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
20-12-2007 13:08:16  ReadString OK
20-12-2007 13:08:16  pfReadRegistry: "C:\Program Files\PLSQL Developer\PlSqlDev.exe" "%1"
20-12-2007 13:08:16  LoadPreferences
20-12-2007 13:08:16  LoadPreferences searching for default
20-12-2007 13:08:16    C:\Program Files\PLSQL Developer\Preferences\CP\default.ini
20-12-2007 13:08:16  LoadPreferences NewPref := nil
20-12-2007 13:08:16  LoadPreferences 
20-12-2007 13:08:16  LoadPreferences Reading preferences
20-12-2007 13:08:16  pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
20-12-2007 13:08:16  ReadString OK
20-12-2007 13:08:16  pfReadRegistry: "C:\Program Files\PLSQL Developer\PlSqlDev.exe" "%1"
20-12-2007 13:08:16  LoadPreferences ReadPosition
20-12-2007 13:08:16  LoadPreferences ToolsBrowserItemClick(nil)
20-12-2007 13:08:16  LoadPreferences CreateBrowserFilters...
20-12-2007 13:08:16  LoadPreferences Files
20-12-2007 13:08:16  LoadPreferences Logon
20-12-2007 13:08:16  LoadPreferences Buttons
20-12-2007 13:08:16  LoadPreferences Printer
20-12-2007 13:08:16  LoadPreferences BrowserFolders
20-12-2007 13:08:16  LoadPreferences 
20-12-2007 13:08:16  LoadPreferences end
20-12-2007 13:08:16  MacroLibFilename: C:\Program Files\PLSQL Developer\Macro\CP.lib
20-12-2007 13:08:16  FormCreate TDBNames.Make
20-12-2007 13:08:16  FormCreate SessionChanged
20-12-2007 13:08:16  SessionChanged SetDBAViews
20-12-2007 13:08:16  SessionChanged Authorizations.Load
20-12-2007 13:08:16  SessionChanged EnableAuthorizedMenus
20-12-2007 13:08:16  ExecuteConnectScript starts
20-12-2007 13:08:16  ExecuteConnectScript ends
20-12-2007 13:08:16  SessionChanged LoadRecentObjects
20-12-2007 13:08:16  SessionChanged Notify children
20-12-2007 13:08:16  SessionChanged Logoff secondary sessions
20-12-2007 13:08:16  SessionChanged SessionMode = smMulti
20-12-2007 13:08:16  SessionChanged EnableChildFunctions
20-12-2007 13:08:16  SessionChanged
20-12-2007 13:08:17  SortPreferenceSets
20-12-2007 13:08:17   - Default CP
20-12-2007 13:08:17   - System Default
20-12-2007 13:08:17  WMUpdatePopups starts
20-12-2007 13:08:17  GetCrashList: 459294.cfg
20-12-2007 13:08:17  LoadDesktop starts
20-12-2007 13:08:17  LoadDesktop ends
20-12-2007 13:08:17  WMUpdatePopups ends
20-12-2007 13:08:20  TOracleSession PLSQLDevForm.Session Start Session.LogOn as std70_udv@thebe
20-12-2007 13:08:20  TOracleQuery BytesPerCharacterQuery Start Query.Execute
                     SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3,  length(chr(20000)) l2, 'c' c1 from dual
20-12-2007 13:08:20  TOracleQuery BytesPerCharacterQuery End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:20  TOracleQuery BytesPerCharacterQuery Start Query.Execute
                     SQL = select lengthb(nchr(20)), nchr(20) from dual
20-12-2007 13:08:20  TOracleQuery BytesPerCharacterQuery End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:20  TOracleQuery Query Start Query.Execute
                     SQL = select to_char(userenv('SESSIONID')) from dual
20-12-2007 13:08:20  TOracleQuery Query End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:20  TOracleSession PLSQLDevForm.Session End
                     Duration = 0,125
20-12-2007 13:08:20  TOracleQuery Query Start Query.Execute
                     SQL = select * from v$version
20-12-2007 13:08:20  TOracleQuery Query End  (5 records processed)
                     Duration = 0
20-12-2007 13:08:20  SessionChanged SetDBAViews
20-12-2007 13:08:20  TOracleQuery $02A995C0 Start Query.Execute
                     SQL = select null from all_synonyms where 1=0
20-12-2007 13:08:20  TOracleQuery $02A995C0 End  (0 records processed)
                     Duration = 0
20-12-2007 13:08:20  TOracleQuery $02A995C0 Start Query.Execute
                     SQL = select null from dba_synonyms where 1=0
20-12-2007 13:08:20  TOracleQuery $02A995C0 End  (0 records processed)
                     Duration = 0,016
20-12-2007 13:08:20  SessionChanged Authorizations.Load
20-12-2007 13:08:20  TOracleQuery $02A99460 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)
20-12-2007 13:08:20  TOracleQuery $02A99460 End
                     Result = ORA-00942: table or view does not exist
                     Duration = 0,015
20-12-2007 13:08:20  SessionChanged ApplyPreferences
20-12-2007 13:08:20  SortPreferenceSets
20-12-2007 13:08:20   - Default CP
20-12-2007 13:08:20   - System Default
20-12-2007 13:08:20  SessionChanged EnableAuthorizedMenus
20-12-2007 13:08:20  TOracleSession $033A6E70 Start Session.LogOn as std70_udv@thebe
20-12-2007 13:08:20  TOracleQuery Query Start Query.Execute
                     SQL = select to_char(userenv('SESSIONID')) from dual
20-12-2007 13:08:20  TOracleQuery Query End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:20  TOracleSession $033A6E70 End
                     Duration = 0,078
20-12-2007 13:08:21  SetSessionAction starts: Main session
20-12-2007 13:08:21  TOracleQuery $02A99880 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')
20-12-2007 13:08:21  TOracleQuery $02A995C0 Start Query.Execute
                     SQL = select null from dual
20-12-2007 13:08:21  TOracleQuery $02A995C0 End  (1 record processed)
                     Duration = 0,015
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,015
20-12-2007 13:08:21  TOracleQuery $02A995C0 Start Query.Execute
                     SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
                     :ACTION = Main session
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  TOracleQuery $02A995C0 End
                     Duration = 0
20-12-2007 13:08:21  SetSessionAction ends
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:21  ExecuteConnectScript starts
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  ExecuteConnectScript ends
20-12-2007 13:08:21  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
                     SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:21  TOracleQuery PLSQLDevForm.DynamicQuery End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  SessionChanged LoadRecentObjects
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,015
20-12-2007 13:08:21  SessionChanged Notify children
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  SessionChanged Logoff secondary sessions
20-12-2007 13:08:21  SessionChanged SessionMode = smMulti
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:21  SessionChanged EnableChildFunctions
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,015
20-12-2007 13:08:21  SessionChanged
                     OracleHomeKey: SOFTWARE\ORACLE\HOME0
                     OracleHomeDir: C:\orant
                     Found: oci.dll
                     Found: ORA803.DLL
                     Found: ORA804.DLL
                     Found: ORA805.DLL
                     Using: C:\orant\bin\oci.dll
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:21  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
                     SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  TOracleQuery PLSQLDevForm.DynamicQuery End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:21  LogonHistorySave start
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:21  ChangeUserPref LogonHistory,
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  ChangeUserPref DSA,
20-12-2007 13:08:21  ChangeUserPref end
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:21  ChangeUserPref ColumnAssociations,
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  ChangeUserPref end
20-12-2007 13:08:21  ChangeUserPref ImportAssociations,
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:21  ChangeUserPref end
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  ChangeUserPref BrowserFilters,
20-12-2007 13:08:21  ChangeUserPref end
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:21  ChangeUserPref BrowserFolders,
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  ChangeUserPref end
20-12-2007 13:08:21  ChangeUserPref SessionQueries,
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:21  ChangeUserPref end
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  ChangeUserPref ExternalTools,
20-12-2007 13:08:21  ChangeUserPref end
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:21  ChangeUserPref Documents,
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  ChangeUserPref end
20-12-2007 13:08:21  ChangeUserPref Reports,
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:21  ChangeUserPref end
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  LogonHistorySave end
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (89 records processed)
                     Duration = 0
20-12-2007 13:08:21  TOracleQuery $02A99880 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')
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,578
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,015
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:21  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:21  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,156
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,015
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,031
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,015
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,062
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,078
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Execute
                     SQL = select /*+rule*/  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$%'

                     and (owner = user)
                     order by decode(owner, user, 0, 1),
                     owner,
                     object_name
                     :OBJECT_TYPE = PACKAGE
                     :EXTRA_CONDITION =
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,015
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery End  (100 records processed)
                     Duration = 0,031
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (100 records processed)
                     Duration = 0,015
20-12-2007 13:08:22  TOracleQuery $02A99880 Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery Start Query.Next for up to 100 records
20-12-2007 13:08:22  TOracleQuery PLSQLDevForm.ObjectQuery End  (48 records processed)
                     Duration = 0
20-12-2007 13:08:22  TOracleQuery $02A99880 End  (50 records processed)
                     Duration = 0,219
20-12-2007 13:08:22  TOracleSession $033A6E70 Start Session.LogOff
20-12-2007 13:08:22  TOracleSession $033A6E70 End
                     Duration = 0
20-12-2007 13:08:24  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'ACTIVITY_FILTER_BIZ'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = ACTIVITY_FILTER_BIZ
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:24  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,015
20-12-2007 13:08:24  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'T2M_DESCRIPTION'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = T2M_DESCRIPTION
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:24  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,015
20-12-2007 13:08:24  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEMP_TAB_BAS'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEMP_TAB_BAS
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:24  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:24  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_ACTIVITY_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_ACTIVITY_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:24  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:25  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_ACTIVITY_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_ACTIVITY_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:25  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:25  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_ACTIVITY_TYPE_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_ACTIVITY_TYPE_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:25  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:26  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_ADDRESS_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_ADDRESS_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:26  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,031
20-12-2007 13:08:26  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_ADDRESS_CODE_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_ADDRESS_CODE_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:26  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:26  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_API_REGRESSION'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_API_REGRESSION
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:26  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:26  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_API_REGRESSION_POST'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_API_REGRESSION_POST
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:26  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:26  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_API_REGRESSION_PRE'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_API_REGRESSION_PRE
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:26  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:26  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_APL_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_APL_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:26  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,015
20-12-2007 13:08:26  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_APL_ITEM_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_APL_ITEM_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:26  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:27  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_APPLICATION_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_APPLICATION_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:27  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,015
20-12-2007 13:08:27  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_ASSEMBLY_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_ASSEMBLY_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:27  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:27  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_COST_ACCOUNT_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_COST_ACCOUNT_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:27  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:27  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_COUNTRY_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_COUNTRY_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:27  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,015
20-12-2007 13:08:27  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_CURRENCY_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_CURRENCY_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:27  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,015
20-12-2007 13:08:27  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DEFAULT_EMAIL_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DEFAULT_EMAIL_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:27  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:28  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DELIVERY_ADDRESS_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DELIVERY_ADDRESS_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:28  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,015
20-12-2007 13:08:28  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DELIVERY_TERM_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DELIVERY_TERM_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:28  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:28  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DEPARTMENT_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DEPARTMENT_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:28  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:28  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DPL_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DPL_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:28  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:28  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DPL_ITEM_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DPL_ITEM_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:28  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:28  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DRAWING_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DRAWING_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:28  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:28  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DRAW_DISCIPLINE_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DRAW_DISCIPLINE_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:28  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:28  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_EMAIL_TYPE_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_EMAIL_TYPE_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:28  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:28  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_EXTERNAL_RESOURCE_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_EXTERNAL_RESOURCE_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:28  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:29  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_GUI_COMPONENT_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_GUI_COMPONENT_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:29  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,016
20-12-2007 13:08:29  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_EXTERNAL_RESOURCE_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_EXTERNAL_RESOURCE_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:29  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:29  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_EMAIL_TYPE_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_EMAIL_TYPE_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:29  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:29  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DRAW_DISCIPLINE_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DRAW_DISCIPLINE_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:29  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,015
20-12-2007 13:08:29  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DRAWING_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DRAWING_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:29  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:29  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DPL_ITEM_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DPL_ITEM_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:29  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0,015
20-12-2007 13:08:31  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  text from sys.all_source
                     where owner = :owner
                     and name = :name
                     and type = :type
                     order by line
                     :OWNER = STD70_UDV
                     :NAME = TEST_DPL_API
                     :TYPE = PACKAGE
20-12-2007 13:08:31  TOracleQuery $02A99300 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:31  TOracleQuery $02A99300 Start Query.Next for up to 100 records
20-12-2007 13:08:31  TOracleQuery $02A99300 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:31  TOracleQuery $02A99300 Start Query.Next for up to 100 records
20-12-2007 13:08:31  TOracleQuery $02A99300 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:32  TOracleQuery $02A99300 Start Query.Next for up to 100 records
20-12-2007 13:08:32  TOracleQuery $02A99300 End  (9 records processed)
                     Duration = 0
20-12-2007 13:08:33  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DPL_API'
                        and po.object_type = 'FUNCTION'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DPL_API
                     :OBJECT_TYPE = FUNCTION
20-12-2007 13:08:33  TOracleQuery $02A99300 End  (0 records processed)
                     Duration = 0
20-12-2007 13:08:33  AddPlugInPopups Start 0
20-12-2007 13:08:33  AddPlugInPopups End
20-12-2007 13:08:34  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  * 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 = STD70_UDV
                     :OBJECT_NAME = TEST_DPL_API
                     :SUB_OBJECT = Null
20-12-2007 13:08:34  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:34  TOracleQuery $02A99300 Start Query.Execute
                     SQL = select /*+rule*/  * 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 = STD70_UDV
                     :OBJECT_NAME = TEST_DPL_API
                     :SUB_OBJECT = Null
20-12-2007 13:08:34  TOracleQuery $02A99300 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:34  Create TTestForm Start
20-12-2007 13:08:34  Create TTestForm Inherited
20-12-2007 13:08:34  Create TTestForm SetupMainFont
20-12-2007 13:08:34  Create TTestForm Activate
20-12-2007 13:08:34  Create TTestForm Activate done
20-12-2007 13:08:34  Create TTestForm UpdateWindowList
20-12-2007 13:08:34  Create TTestForm Positioning
20-12-2007 13:08:34  Create TTestForm Finished
20-12-2007 13:08:34  NavigationBookmarks.EnableButtons(Rebuild)
20-12-2007 13:08:34  NavigationBookmarks: Backward=0, Forward=0
20-12-2007 13:08:51  AddNavigationBookmark starts
20-12-2007 13:08:51  AddNavigationBookmark GNV00001
20-12-2007 13:08:51  NavigationBookmarks.EnableButtons(Rebuild)
20-12-2007 13:08:51  NavigationBookmarks: Backward=1, Forward=0
20-12-2007 13:08:51  AddNavigationBookmark ends
20-12-2007 13:08:53  TOracleQuery $02A98EE0 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'TEST_DRAW_DISCIPLINE_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = TEST_DRAW_DISCIPLINE_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:53  TOracleQuery $02A98EE0 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:54  TOracleQuery $02A98EE0 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'DRAWING_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = DRAWING_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:54  TOracleQuery $02A98EE0 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:54  TOracleQuery $02A98EE0 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'DRAWING_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = DRAWING_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:54  TOracleQuery $02A98EE0 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:54  TOracleQuery $02A98EE0 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'DRAWING_BIZ'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = DRAWING_BIZ
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:54  TOracleQuery $02A98EE0 End  (1 record processed)
                     Duration = 0,015
20-12-2007 13:08:54  TOracleQuery $02A98EE0 Start Query.Execute
                     SQL = select /*+rule*/  debuginfo
                       from sys.all_probe_objects po
                      where po.owner = 'STD70_UDV'
                        and po.object_name = 'DRAW_API'
                        and po.object_type = 'PACKAGE'
                     :OBJECT_OWNER = STD70_UDV
                     :OBJECT_NAME = DRAW_API
                     :OBJECT_TYPE = PACKAGE
20-12-2007 13:08:55  TOracleQuery $02A98EE0 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:56  Create TProcEditForm Start
20-12-2007 13:08:56  Create TProcEditForm Inherited
20-12-2007 13:08:56  Create TProcEditForm SetupMainFont
20-12-2007 13:08:56  Create TProcEditForm Activate
20-12-2007 13:08:56  Create TProcEditForm Activate done
20-12-2007 13:08:56  Create TProcEditForm UpdateWindowList
20-12-2007 13:08:56  Create TProcEditForm Positioning
20-12-2007 13:08:56  Create TProcEditForm Finished
20-12-2007 13:08:56  TOracleQuery $02A98D80 Start Query.Execute
                     SQL = select /*+rule*/  text from sys.all_source
                     where owner = :owner
                     and name = :name
                     and type = :type
                     order by line
                     :OWNER = STD70_UDV
                     :NAME = DRAW_API
                     :TYPE = PACKAGE
20-12-2007 13:08:56  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:56  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:56  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:56  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:56  TOracleQuery $02A98D80 End  (89 records processed)
                     Duration = 0
20-12-2007 13:08:56  TOracleQuery PLSQLDevForm.ProgErrorQuery Start Query.Execute
                     SQL = select /*+rule*/  *
                     from sys.all_errors
                     where name = :name and type = :type and owner = :owner
                     order by sequence
                     :NAME = DRAW_API
                     :TYPE = PACKAGE
                     :OWNER = STD70_UDV
20-12-2007 13:08:56  TOracleQuery PLSQLDevForm.ProgErrorQuery End  (0 records processed)
                     Duration = 0
20-12-2007 13:08:56  ProcEditForm.GetTabNames
20-12-2007 13:08:56   + draw_api
20-12-2007 13:08:56  ProcEditForm.GetTabNames done
20-12-2007 13:08:56  NavigationBookmarks.EnableButtons(Rebuild)
20-12-2007 13:08:56  NavigationBookmarks: Backward=1, Forward=0
20-12-2007 13:08:56  UpdateContents(Clear)
20-12-2007 13:08:56  Source = CREATE OR REPLACE PACKAGE draw_api AS
20-12-2007 13:08:56  UpdatingContents: Thread Started
20-12-2007 13:08:56  ContentsThread: Execute
20-12-2007 13:08:56  ContentsThread: Analyze
20-12-2007 13:08:57  ContentsThread: Valid
20-12-2007 13:08:57  ContentsThread: Suspend started
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Execute
                     SQL = select /*+rule*/  * 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 = STD70_UDV
                     :OBJECT_NAME = DRAW_API
                     :SUB_OBJECT = Null
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (1 record processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Execute
                     SQL = select /*+rule*/  text from sys.all_source
                     where owner = :owner
                     and name = :name
                     and type = :type
                     order by line
                     :OWNER = STD70_UDV
                     :NAME = DRAW_API
                     :TYPE = PACKAGE BODY
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (88 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Execute
                     SQL = select /*+rule*/  text from sys.all_source
                     where owner = :owner
                     and name = :name
                     and type = :type
                     order by line
                     :OWNER = STD70_UDV
                     :NAME = DRAW_API
                     :TYPE = PACKAGE BODY
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0,016
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0,015
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (100 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery $02A98D80 Start Query.Next for up to 100 records
20-12-2007 13:08:57  TOracleQuery $02A98D80 End  (88 records processed)
                     Duration = 0
20-12-2007 13:08:57  TOracleQuery PLSQLDevForm.ProgErrorQuery Start Query.Execute
                     SQL = select /*+rule*/  *
                     from sys.all_errors
                     where name = :name and type = :type and owner = :owner
                     order by sequence
                     :NAME = DRAW_API
                     :TYPE = PACKAGE BODY
                     :OWNER = STD70_UDV
20-12-2007 13:08:57  TOracleQuery PLSQLDevForm.ProgErrorQuery End  (0 records processed)
                     Duration = 0
20-12-2007 13:08:57  ProcEditForm.GetTabNames
20-12-2007 13:08:57   + draw_api
20-12-2007 13:08:57   + draw_api
20-12-2007 13:08:57  ProcEditForm.GetTabNames done
20-12-2007 13:08:57  NavigationBookmarks.EnableButtons(Rebuild)
20-12-2007 13:08:57  NavigationBookmarks: Backward=1, Forward=0
20-12-2007 13:08:57  UpdateContents(Clear)
20-12-2007 13:08:57  Source = CREATE OR REPLACE PACKAGE BODY
20-12-2007 13:08:57  ContentsThread: Resume
20-12-2007 13:08:57  UpdatingContents: Thread Started
20-12-2007 13:08:57  ContentsThread: Analyze
20-12-2007 13:08:57  ContentsThread: Valid
20-12-2007 13:08:57  ContentsThread: Suspend started
20-12-2007 13:08:57  NavigationBookmarks.EnableButtons(Rebuild)
20-12-2007 13:08:57  NavigationBookmarks: Backward=1, Forward=0
20-12-2007 13:08:57  UpdateContents(Clear)
20-12-2007 13:08:57  Source = CREATE OR REPLACE PACKAGE BODY
20-12-2007 13:08:57  UpdatingContents: Thread Started
20-12-2007 13:08:57  ContentsThread: Resume
20-12-2007 13:08:57  ContentsThread: Analyze
20-12-2007 13:08:57  AddNavigationBookmark starts
20-12-2007 13:08:57  AddNavigationBookmark GNV00002
20-12-2007 13:08:57  NavigationBookmarks.EnableButtons(Rebuild)
20-12-2007 13:08:57  NavigationBookmarks: Backward=2, Forward=0
20-12-2007 13:08:57  AddNavigationBookmark ends
20-12-2007 13:08:57  ContentsThread: Valid
20-12-2007 13:08:57  ContentsUpdated
20-12-2007 13:08:57  ContentsThread: Suspend started
20-12-2007 13:08:57  ContentsUpdated: Valid
20-12-2007 13:08:57  ContentsUpdated: Refresh Code Contents
20-12-2007 13:08:57  ContentsUpdated
20-12-2007 13:08:57  ContentsUpdated: Valid
20-12-2007 13:08:57  ContentsUpdated: Refresh Code Contents
20-12-2007 13:08:57  NavigationBookmarks.EnableButtons(Rebuild)
20-12-2007 13:08:57  NavigationBookmarks: Backward=2, Forward=0
20-12-2007 13:08:57  ContentsUpdated
20-12-2007 13:08:57  ContentsUpdated: Valid
20-12-2007 13:08:57  ContentsUpdated: Refresh Code Contents
20-12-2007 13:08:59  AddNavigationBookmark starts
20-12-2007 13:08:59  NavigationBookmarks.EnableButtons(Rebuild)
20-12-2007 13:08:59  NavigationBookmarks: Backward=2, Forward=0
20-12-2007 13:08:59  AddNavigationBookmark ends
20-12-2007 13:09:03  AddNavigationBookmark starts
20-12-2007 13:09:03  AddNavigationBookmark GNV00003
20-12-2007 13:09:03  NavigationBookmarks.EnableButtons(Rebuild)
20-12-2007 13:09:03  NavigationBookmarks: Backward=3, Forward=0
20-12-2007 13:09:03  AddNavigationBookmark ends
20-12-2007 13:09:03  NavigationBookmarks.EnableButtons(Rebuild)
20-12-2007 13:09:03  NavigationBookmarks: Backward=3, Forward=0
20-12-2007 13:09:05  SetConnected starts
20-12-2007 13:09:05  SetConnected: ForceLogoff starts
20-12-2007 13:09:05  SetConnected: ForceLogoff ends
20-12-2007 13:09:05  SetConnected: Connect starts
20-12-2007 13:09:05  TOracleSession $033ABFD0 Start Session.LogOn as std70_udv@thebe
20-12-2007 13:09:05  TOracleQuery Query Start Query.Execute
                     SQL = select to_char(userenv('SESSIONID')) from dual
20-12-2007 13:09:05  TOracleQuery Query End  (1 record processed)
                     Duration = 0
20-12-2007 13:09:05  TOracleSession $033ABFD0 End
                     Duration = 0,047
20-12-2007 13:09:05  SetConnected: (Dis)connect ends
20-12-2007 13:09:05  SetSessionAction starts: Test Window - Script for function TEST_DPL_API.RUN@THEBE
20-12-2007 13:09:05  TOracleQuery $033E38A0 Start Query.Execute
                     SQL = select null from dual
20-12-2007 13:09:05  TOracleQuery $033E38A0 End  (1 record processed)
                     Duration = 0
20-12-2007 13:09:05  TOracleQuery BytesPerCharacterQuery Start Query.Execute
                     SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3,  length(chr(20000)) l2, 'c' c1 from dual
20-12-2007 13:09:05  TOracleQuery BytesPerCharacterQuery End  (1 record processed)
                     Duration = 0
20-12-2007 13:09:05  TOracleQuery BytesPerCharacterQuery Start Query.Execute
                     SQL = select lengthb(nchr(20)), nchr(20) from dual
20-12-2007 13:09:05  TOracleQuery BytesPerCharacterQuery End  (1 record processed)
                     Duration = 0
20-12-2007 13:09:05  TOracleQuery $033E38A0 Start Query.Execute
                     SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
                     :ACTION = Test Window - Script for function TEST_DPL_API.RUN@THEBE
20-12-2007 13:09:05  TOracleQuery $033E38A0 End
                     Duration = 0
20-12-2007 13:09:05  SetSessionAction ends
20-12-2007 13:09:05  ExecuteConnectScript starts
20-12-2007 13:09:05  ExecuteConnectScript ends
20-12-2007 13:09:05  TOracleQuery $033E38A0 Start Query.Execute
                     SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
20-12-2007 13:09:05  TOracleQuery $033E38A0 End  (1 record processed)
                     Duration = 0
20-12-2007 13:09:05  InitHTPOutput starts
20-12-2007 13:09:05  TOracleQuery $033E38A0 Start Query.Execute
                     SQL = begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
20-12-2007 13:09:05  TOracleQuery $033E38A0 End
                     Duration = 0
20-12-2007 13:09:05  InitHTPOutput finished
20-12-2007 13:09:05  EnableOutput starts
20-12-2007 13:09:05  TOracleQuery PLSQLDevForm.EnableOutputQuery Start Query.Execute
                     SQL = begin
                       if :enable = 0 then
                         sys.dbms_output.disable;
                       else
                         sys.dbms_output.enable(:size);
                       end if;
                     end;
                     :ENABLE = 1
                     :SIZE = 1000000
20-12-2007 13:09:05  TOracleQuery PLSQLDevForm.EnableOutputQuery End
                     Duration = 0
20-12-2007 13:09:05  EnableOutput done
20-12-2007 13:09:05  InitializeTargetSession starts
20-12-2007 13:09:05  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
20-12-2007 13:09:05  TOracleQuery Debugger.InitializeTargetQuery End
                     Duration = 0
20-12-2007 13:09:05  TOracleSession Debugger.Session Start Session.LogOn as std70_udv@thebe
20-12-2007 13:09:05  TOracleQuery BytesPerCharacterQuery Start Query.Execute
                     SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3,  length(chr(20000)) l2, 'c' c1 from dual
20-12-2007 13:09:05  TOracleQuery BytesPerCharacterQuery End  (1 record processed)
                     Duration = 0
20-12-2007 13:09:05  TOracleQuery BytesPerCharacterQuery Start Query.Execute
                     SQL = select lengthb(nchr(20)), nchr(20) from dual
20-12-2007 13:09:05  TOracleQuery BytesPerCharacterQuery End  (1 record processed)
                     Duration = 0
20-12-2007 13:09:05  TOracleQuery Query Start Query.Execute
                     SQL = select to_char(userenv('SESSIONID')) from dual
20-12-2007 13:09:05  TOracleQuery Query End  (1 record processed)
                     Duration = 0
20-12-2007 13:09:05  TOracleSession Debugger.Session End
                     Duration = 0,094
20-12-2007 13:09:05  SetSessionAction starts: Debug Test Window - Script for function TEST_DPL_API.RUN@THEBE
20-12-2007 13:09:05  TOracleQuery $033E38A0 Start Query.Execute
                     SQL = select null from dual
20-12-2007 13:09:05  TOracleQuery $033E38A0 End  (1 record processed)
                     Duration = 0
20-12-2007 13:09:05  TOracleQuery $033E38A0 Start Query.Execute
                     SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
                     :ACTION = Debug Test Window - Script for function TEST_DPL_API.RUN@THEBE
20-12-2007 13:09:05  TOracleQuery $033E38A0 End
                     Duration = 0
20-12-2007 13:09:05  SetSessionAction ends
20-12-2007 13:09:05  ExecuteConnectScript starts
20-12-2007 13:09:05  ExecuteConnectScript ends
20-12-2007 13:09:05  InitializeTargetSession ends
20-12-2007 13:09:05  InitStatistics starts
20-12-2007 13:09:05  TStatistics.Init starts
20-12-2007 13:09:05  InitStatNames starts
20-12-2007 13:09:05  select name from v$statname order by statistic#
20-12-2007 13:09:05  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
                     SQL = select name from v$statname order by statistic#
20-12-2007 13:09:05  TOracleQuery PLSQLDevForm.DynamicQuery End  (25 records processed)
                     Duration = 0
20-12-2007 13:09:05  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
20-12-2007 13:09:05  TOracleQuery PLSQLDevForm.DynamicQuery End  (25 records processed)
                     Duration = 0
20-12-2007 13:09:05  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
20-12-2007 13:09:05  TOracleQuery PLSQLDevForm.DynamicQuery End  (25 records processed)
                     Duration = 0
20-12-2007 13:09:05  TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
20-12-2007 13:09:05  TOracleQuery PLSQLDevForm.DynamicQuery End  (25 records processed)
                     Duration = 0
20-12-2007 13:09:05  TOracleQuery PLSQLDevForm.DynamicQ
 
Would it be possible to prevent PLD from hanging up and just show the Oracle error so I could continue my test in another way? I had to kill the PLD program process and start over with a recovery file that was not quite up-to-date.

I know that you can not totally avoid program crashes, but please make a big effort to prevent PLD from hanging on unexpected errors. Just display some error information and give the user a chance to save his work before closing the program.
 
Back
Top