Instance termination whilst debugging with PLSQL Developer >=7.1.x

J

JDietz

Member²
Hello,

last week we found a serious issue whilst debugging a certain piece of PLSQL code running on a 10.2.0.3 x64 Enterprise Edition on Win2k3 with PLSQL Developer >= 7.1.x or 8.0:
Everytime we step over a certain "for cs in (select ...)" the whole instance terminates without any crash dump or alert messages. Just an application event log is recorded:

Faulting application oracle.exe, version 10.2.0.3, faulting module orapls10.dll, version 10.2.0.3, fault address 0x000000000000e150.

Are there any ways to trace what the debug module of the PLSQL Developer does while we debug that special piece of code?

The 7.0.x versions seem not have that problem. With for example PLSQL Developer 7.0.3 that certain piece of code can perfectly be debugged.
Also the PLSQL code runs perfect in normal execution mode.

We also tried the different PLSQL Developer versions on different clients (x86, x64, instant client, standard client 9.2, standard client 10.2, etc.) but the result was always the same: 7.0.x worked and >= 7.1.x crashed the instance

Regards,
J
 
Last edited:
To see what PL/SQL Developer is doing, you can modify the shortcut and add the debugsql parameter. For example:

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

This will create a debug.txt file in the PL/SQL Developer directory that shows all SQL sent to the server (and more).
 
Hello Marco,

this is what I got back with "debugsql" on:

PL/SQL Developer
Version 8.0.0.1480
Windows 2003 Enterprise Edition (64-bit) 5.2 Build 3790 (Service Pack 1)

Physical memory : 4.194.304 kB (4.194.304 available)
Paging file : 4.194.304 kB (4.194.304 available)
Virtual memory : 2.097.024 kB (2.015.996 available)

Parameters
C:\TEMP\PLSQL Developer 8.0\plsqldev.exe
debugsql

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

Preference Files

Plug-Ins

24.11.2009 13:41:49 Application started
24.11.2009 13:41:49 InitPreferences
24.11.2009 13:41:49 Load C:\TEMP\PLSQL Developer 8.0\Preferences\Default = 0
24.11.2009 13:41:49 PreferenceSet.Load C:\TEMP\PLSQL Developer 8.0\Preferences\Default\Default.ini
24.11.2009 13:41:49 PreferenceSet.Load OK
24.11.2009 13:41:49 Determine LocalPrefPath
24.11.2009 13:41:49 [1]: C:\TEMP\PLSQL Developer 8.0\Preferences
24.11.2009 13:41:49 LocalPrefPath: C:\TEMP\PLSQL Developer 8.0\Preferences\jdietz
24.11.2009 13:41:49 Load C:\TEMP\PLSQL Developer 8.0\Preferences\jdietz = 0
24.11.2009 13:41:49 PreferenceSet.Load C:\TEMP\PLSQL Developer 8.0\Preferences\jdietz\default.ini
24.11.2009 13:41:49 PreferenceSet.Load OK
24.11.2009 13:41:49 PreferenceSet.Load C:\TEMP\PLSQL Developer 8.0\Preferences\jdietz\user.prefs
24.11.2009 13:41:49 PreferenceSet.Load OK
24.11.2009 13:41:49 InitPreferences end
24.11.2009 13:41:49 SortPreferenceSets
24.11.2009 13:41:49 - Default jdietz
24.11.2009 13:41:49 - System Default
24.11.2009 13:41:49 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
24.11.2009 13:41:49 ReadString OK
24.11.2009 13:41:49 pfReadRegistry: "c:\program files 32\plsql developer\plsqldev.exe"
24.11.2009 13:41:49 LoadPreferences
24.11.2009 13:41:49 LoadPreferences searching for default
24.11.2009 13:41:49 C:\TEMP\PLSQL Developer 8.0\Preferences\jdietz\default.ini
24.11.2009 13:41:49 LoadPreferences NewPref := nil
24.11.2009 13:41:49 LoadPreferences
24.11.2009 13:41:49 LoadPreferences Reading preferences
24.11.2009 13:41:49 LoadPreferences ReadPosition
24.11.2009 13:41:49 LoadPreferences ToolsBrowserItemClick(nil)
24.11.2009 13:41:49 LoadPreferences CreateBrowserFilters...
24.11.2009 13:41:49 LoadPreferences Files
24.11.2009 13:41:49 LoadPreferences Logon
24.11.2009 13:41:49 LoadPreferences Buttons
24.11.2009 13:41:49 LoadPreferences Printer
24.11.2009 13:41:49 LoadPreferences FileBrowserFolders
24.11.2009 13:41:49 LoadPreferences BrowserFolders
24.11.2009 13:41:49 LoadPreferences
24.11.2009 13:41:49 LoadPreferences end
24.11.2009 13:41:49 MacroLibFilename: C:\TEMP\PLSQL Developer 8.0\Macro\jdietz.lib
24.11.2009 13:41:49 FormCreate Logon.Execute
24.11.2009 13:41:51 TOracleSession PLSQLDevForm.Session Start Session.LogOn as lbs_user@VWKS_10_DEV
24.11.2009 13:41:52 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
24.11.2009 13:41:52 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
24.11.2009 13:41:52 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
24.11.2009 13:41:52 TOracleQuery Query End (1 record processed)
Duration = 0,016
24.11.2009 13:41:52 TOracleSession PLSQLDevForm.Session End
Duration = 0,329
24.11.2009 13:41:52 LogonHistorySave start
24.11.2009 13:41:52 ChangeUserPref LogonHistory,
24.11.2009 13:41:52 ChangeUserPref DSA,
24.11.2009 13:41:52 ChangeUserPref end
24.11.2009 13:41:52 ChangeUserPref ColumnAssociations,
24.11.2009 13:41:52 ChangeUserPref end
24.11.2009 13:41:52 ChangeUserPref ImportAssociations,
24.11.2009 13:41:52 ChangeUserPref end
24.11.2009 13:41:52 ChangeUserPref BrowserFilters,
24.11.2009 13:41:52 ChangeUserPref end
24.11.2009 13:41:52 ChangeUserPref FileBrowserFolders,
24.11.2009 13:41:52 ChangeUserPref end
24.11.2009 13:41:52 ChangeUserPref BrowserFolders,
24.11.2009 13:41:52 ChangeUserPref end
24.11.2009 13:41:52 ChangeUserPref SessionQueries,
24.11.2009 13:41:52 ChangeUserPref end
24.11.2009 13:41:52 ChangeUserPref ExternalTools,
24.11.2009 13:41:52 ChangeUserPref end
24.11.2009 13:41:52 ChangeUserPref Documents,
24.11.2009 13:41:52 ChangeUserPref end
24.11.2009 13:41:52 ChangeUserPref Reports,
24.11.2009 13:41:52 ChangeUserPref end
24.11.2009 13:41:52 LogonHistorySave end
24.11.2009 13:41:52 FormCreate Session.Connected
24.11.2009 13:41:52 FormCreate Logon.Executed -1
24.11.2009 13:41:52 FormCreate TDBNames.Make
24.11.2009 13:41:52 FormCreate SessionChanged
24.11.2009 13:41:52 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
24.11.2009 13:41:52 TOracleQuery Query End (5 records processed)
Duration = 0
24.11.2009 13:41:52 SessionChanged SetDBAViews
24.11.2009 13:41:52 TOracleQuery $04186620 Start Query.Execute
SQL = select null from all_synonyms where 1=0
24.11.2009 13:41:52 TOracleQuery $04186620 End (0 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186620 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
24.11.2009 13:41:52 TOracleQuery $04186620 End (0 records processed)
Duration = 0
24.11.2009 13:41:52 SessionChanged Authorizations.Load
24.11.2009 13:41:52 TOracleQuery $04186620 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)
24.11.2009 13:41:52 TOracleQuery $04186620 End
Result = ORA-00942: table or view does not exist
Duration = 0
24.11.2009 13:41:52 SessionChanged EnableAuthorizedMenus
24.11.2009 13:41:52 ExecuteConnectScript starts
24.11.2009 13:41:52 TOracleQuery $04186620 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
24.11.2009 13:41:52 TOracleQuery $04186620 End
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186620 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
24.11.2009 13:41:52 TOracleQuery $04186620 End
Duration = 0,015
24.11.2009 13:41:52 ExecuteConnectScript ends
24.11.2009 13:41:52 TOracleQuery $04186620 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
24.11.2009 13:41:52 TOracleQuery $04186620 End (1 record processed)
Duration = 0
24.11.2009 13:41:52 TOracleSession $041ECD90 Start Session.LogOn as lbs_user@VWKS_10_DEV
24.11.2009 13:41:52 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
24.11.2009 13:41:52 TOracleQuery Query End (1 record processed)
Duration = 0,016
24.11.2009 13:41:52 TOracleSession $041ECD90 End
Duration = 0,063
24.11.2009 13:41:52 SetSessionAction starts: Main session
24.11.2009 13:41:52 TOracleQuery $041864C0 Start Query.Execute
SQL = select null from dual
24.11.2009 13:41:52 TOracleQuery $041864C0 End (1 record processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $041864C0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
24.11.2009 13:41:52 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
24.11.2009 13:41:52 TOracleQuery $041864C0 End
Duration = 0
24.11.2009 13:41:52 SetSessionAction ends
24.11.2009 13:41:52 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
24.11.2009 13:41:52 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
24.11.2009 13:41:52 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Execute
SQL = select object_name, object_type
from sys.all_objects o
where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = LBS_USER
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0,016
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 SessionChanged LoadRecentObjects
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 SessionChanged Notify children
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 SessionChanged Logoff secondary sessions
24.11.2009 13:41:52 SessionChanged SessionMode = smMulti
24.11.2009 13:41:52 SessionChanged EnableChildFunctions
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 SessionChanged
OracleHomeKey:
OracleHomeDir: C:\OracleInstantClient
Found: oci.dll
Using: C:\OracleInstantClient\oci.dll
24.11.2009 13:41:52 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0,016
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (11 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 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', :schema)
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')
:SCHEMA = LBS_USER
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0,047
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 SortPreferenceSets
24.11.2009 13:41:52 - Default jdietz
24.11.2009 13:41:52 - System Default
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0,079
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0,016
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186360 Start Query.Execute
SQL = select null from all_synonyms where 1=0
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186360 End (0 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186360 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
24.11.2009 13:41:52 TOracleQuery $04186360 End (0 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (100 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleQuery $04186780 Start Query.Next for up to 100 records
24.11.2009 13:41:52 TOracleQuery $04186780 End (11 records processed)
Duration = 0
24.11.2009 13:41:52 TOracleSession $041ECD90 Start Session.LogOff
24.11.2009 13:41:52 TOracleSession $041ECD90 End
Duration = 0
24.11.2009 13:41:52 WMUpdatePopups starts
24.11.2009 13:41:52 LoadDesktop starts
24.11.2009 13:41:52 LoadDesktop ends
24.11.2009 13:41:52 WMUpdatePopups ends
24.11.2009 13:41:56 Create TTestForm Start
24.11.2009 13:41:56 Create TTestForm Inherited
24.11.2009 13:41:56 Create TTestForm SetupMainFont
24.11.2009 13:41:56 Create TTestForm Activate
24.11.2009 13:41:56 Create TTestForm Activate done
24.11.2009 13:41:56 Create TTestForm UpdateWindowList
24.11.2009 13:41:56 Create TTestForm Positioning
24.11.2009 13:41:56 Create TTestForm Finished
24.11.2009 13:41:56 FileAge: C:\TEMP\lmfc_ipoint.tst = 11:20:50
24.11.2009 13:41:56 NavigationBookmarks.EnableButtons(Rebuild)
24.11.2009 13:41:56 NavigationBookmarks: Backward=0, Forward=0
24.11.2009 13:41:56 CheckFileDate WindowFileDate = 11:20:50
24.11.2009 13:41:56 FileAge: C:\TEMP\lmfc_ipoint.tst = 11:20:50
24.11.2009 13:41:59 TOracleQuery $041860A0 Start Query.Execute
SQL = select * from sys.all_objects
where object_type = :object_type
and owner = :object_owner
and object_name = :object_name
and :sub_object is null
:OBJECT_TYPE = PACKAGE BODY
:OBJECT_OWNER = LBS_USER
:OBJECT_NAME = LMFC_ZZWORKPUTONINBOUND
:SUB_OBJECT = Null
24.11.2009 13:41:59 TOracleQuery $041860A0 End (1 record processed)
Duration = 0,016
24.11.2009 13:41:59 TOracleQuery $041860A0 Start Query.Execute
SQL = select * from sys.all_objects
where object_type = :object_type
and owner = :object_owner
and object_name = :object_name
and :sub_object is null
:OBJECT_TYPE = PACKAGE BODY
:OBJECT_OWNER = LBS_USER
:OBJECT_NAME = LMFC_ZZWORKPUTONINBOUND
:SUB_OBJECT = Null
24.11.2009 13:41:59 TOracleQuery $041860A0 End (1 record processed)
Duration = 0
24.11.2009 13:41:59 AddNavigationBookmark starts
24.11.2009 13:41:59 AddNavigationBookmark GNV00001
24.11.2009 13:41:59 NavigationBookmarks.EnableButtons(Rebuild)
24.11.2009 13:41:59 NavigationBookmarks: Backward=1, Forward=0
24.11.2009 13:41:59 AddNavigationBookmark ends
24.11.2009 13:42:00 TOracleQuery $041860A0 Start Query.Execute
SQL = select debuginfo
from sys.all_probe_objects po
where po.owner = 'LBS_USER'
and po.object_name = 'LMFC_ZZWORKPUTONINBOUND'
and po.object_type = 'PACKAGE BODY'
:OBJECT_OWNER = LBS_USER
:OBJECT_NAME = LMFC_ZZWORKPUTONINBOUND
:OBJECT_TYPE = PACKAGE BODY
24.11.2009 13:42:00 TOracleQuery $041860A0 End (1 record processed)
Duration = 0,031
24.11.2009 13:42:00 AddPlugInPopups Start 0
24.11.2009 13:42:00 AddPlugInPopups End
24.11.2009 13:42:02 Create TProcEditForm Start
24.11.2009 13:42:02 Create TProcEditForm Inherited
24.11.2009 13:42:02 Create TProcEditForm SetupMainFont
24.11.2009 13:42:02 Create TProcEditForm Activate
24.11.2009 13:42:02 Create TProcEditForm Activate done
24.11.2009 13:42:02 Create TProcEditForm UpdateWindowList
24.11.2009 13:42:02 Create TProcEditForm Positioning
24.11.2009 13:42:02 Create TProcEditForm Finished
24.11.2009 13:42:02 TOracleQuery $04185DE0 Start Query.Execute
SQL = select text from sys.all_source
where owner = :owner
and name = :name
and type = :type
order by line
:OWNER = LBS_USER
:NAME = LMFC_ZZWORKPUTONINBOUND
:TYPE = PACKAGE BODY
24.11.2009 13:42:02 TOracleQuery $04185DE0 End (100 records processed)
Duration = 0,078
24.11.2009 13:42:02 TOracleQuery $04185DE0 Start Query.Next for up to 100 records
24.11.2009 13:42:02 TOracleQuery $04185DE0 End (100 records processed)
Duration = 0
24.11.2009 13:42:02 TOracleQuery $04185DE0 Start Query.Next for up to 100 records
24.11.2009 13:42:02 TOracleQuery $04185DE0 End (100 records processed)
Duration = 0
24.11.2009 13:42:02 TOracleQuery $04185DE0 Start Query.Next for up to 100 records
24.11.2009 13:42:02 TOracleQuery $04185DE0 End (100 records processed)
Duration = 0
24.11.2009 13:42:02 TOracleQuery $04185DE0 Start Query.Next for up to 100 records
24.11.2009 13:42:02 TOracleQuery $04185DE0 End (100 records processed)
Duration = 0
24.11.2009 13:42:02 TOracleQuery $04185DE0 Start Query.Next for up to 100 records
24.11.2009 13:42:02 TOracleQuery $04185DE0 End (100 records processed)
Duration = 0
24.11.2009 13:42:02 TOracleQuery $04185DE0 Start Query.Next for up to 100 records
24.11.2009 13:42:02 TOracleQuery $04185DE0 End (88 records processed)
Duration = 0
24.11.2009 13:42:02 TOracleQuery PLSQLDevForm.ProgErrorQuery Start Query.Execute
SQL = select *
from sys.all_errors
where name = :name and type = :type and owner = :owner
order by sequence
:NAME = LMFC_ZZWORKPUTONINBOUND
:TYPE = PACKAGE BODY
:OWNER = LBS_USER
24.11.2009 13:42:02 TOracleQuery PLSQLDevForm.ProgErrorQuery End (0 records processed)
Duration = 0
24.11.2009 13:42:02 ProcEditForm.GetTabNames
24.11.2009 13:42:02 + LMFC_zzWorkPutOnInbound
24.11.2009 13:42:02 ProcEditForm.GetTabNames done
24.11.2009 13:42:02 NavigationBookmarks.EnableButtons(Rebuild)
24.11.2009 13:42:02 NavigationBookmarks: Backward=1, Forward=0
24.11.2009 13:42:02 UpdateContents(Clear)
24.11.2009 13:42:02 Source = create or replace package body LMFC_zzWorkPutOnInbound as
24.11.2009 13:42:02 UpdatingContents: Thread Started
24.11.2009 13:42:02 ContentsThread: Execute
24.11.2009 13:42:02 ContentsThread: Analyze
24.11.2009 13:42:02 ContentsThread: Valid
24.11.2009 13:42:02 ContentsThread: Suspend started
24.11.2009 13:42:02 NavigationBookmarks.EnableButtons(Rebuild)
24.11.2009 13:42:02 NavigationBookmarks: Backward=1, Forward=0
24.11.2009 13:42:02 ContentsUpdated
24.11.2009 13:42:02 ContentsUpdated: Valid
24.11.2009 13:42:02 ContentsUpdated: Refresh Code Contents
24.11.2009 13:42:06 AddNavigationBookmark starts
24.11.2009 13:42:06 AddNavigationBookmark GNV00002
24.11.2009 13:42:06 NavigationBookmarks.EnableButtons(Rebuild)
24.11.2009 13:42:06 NavigationBookmarks: Backward=2, Forward=0
24.11.2009 13:42:06 AddNavigationBookmark ends
24.11.2009 13:42:06 NavigationBookmarks.EnableButtons(Rebuild)
24.11.2009 13:42:06 NavigationBookmarks: Backward=2, Forward=0
24.11.2009 13:42:06 CheckFileDate WindowFileDate = 11:20:50
24.11.2009 13:42:06 FileAge: C:\TEMP\lmfc_ipoint.tst = 11:20:50
24.11.2009 13:42:08 SetConnected starts
24.11.2009 13:42:08 SetConnected: ForceLogoff starts
24.11.2009 13:42:08 SetConnected: ForceLogoff ends
24.11.2009 13:42:08 SetConnected: Connect starts
24.11.2009 13:42:08 TOracleSession $094B68D0 Start Session.LogOn as lbs_user@VWKS_10_DEV
24.11.2009 13:42:08 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
24.11.2009 13:42:08 TOracleQuery Query End (1 record processed)
Duration = 0
24.11.2009 13:42:08 TOracleSession $094B68D0 End
Duration = 0,062
24.11.2009 13:42:08 SetConnected: (Dis)connect ends
24.11.2009 13:42:08 SetSessionAction starts: Test Window - lmfc_ipoint.tst
24.11.2009 13:42:08 TOracleQuery $09410FB0 Start Query.Execute
SQL = select null from dual
24.11.2009 13:42:08 TOracleQuery $09410FB0 End (1 record processed)
Duration = 0
24.11.2009 13:42:08 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
24.11.2009 13:42:08 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
24.11.2009 13:42:08 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
24.11.2009 13:42:08 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
24.11.2009 13:42:08 TOracleQuery $09410FB0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Test Window - lmfc_ipoint.tst
24.11.2009 13:42:08 TOracleQuery $09410FB0 End
Duration = 0
24.11.2009 13:42:08 SetSessionAction ends
24.11.2009 13:42:08 ExecuteConnectScript starts
24.11.2009 13:42:08 TOracleQuery $09410FB0 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
24.11.2009 13:42:08 TOracleQuery $09410FB0 End
Duration = 0
24.11.2009 13:42:08 TOracleQuery $09410FB0 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
24.11.2009 13:42:08 TOracleQuery $09410FB0 End
Duration = 0
24.11.2009 13:42:08 ExecuteConnectScript ends
24.11.2009 13:42:08 TOracleQuery $09410FB0 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
24.11.2009 13:42:08 TOracleQuery $09410FB0 End (1 record processed)
Duration = 0
24.11.2009 13:42:08 InitHTPOutput starts
24.11.2009 13:42:08 TOracleQuery $09410FB0 Start Query.Execute
SQL = begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
24.11.2009 13:42:08 TOracleQuery $09410FB0 End
Duration = 0
24.11.2009 13:42:08 InitHTPOutput finished
24.11.2009 13:42:08 EnableOutput starts
24.11.2009 13:42:08 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
24.11.2009 13:42:08 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
24.11.2009 13:42:08 EnableOutput done
24.11.2009 13:42:08 InitializeTargetSession starts
24.11.2009 13:42:08 Debugger.SetInstance starts
24.11.2009 13:42:08 TOracleQuery $09410FB0 Start Query.Execute
SQL = alter session set instance=1
24.11.2009 13:42:08 TOracleQuery $09410FB0 End
Duration = 0
24.11.2009 13:42:08 Debugger.SetInstance ends
24.11.2009 13:42:08 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
24.11.2009 13:42:09 TOracleQuery Debugger.InitializeTargetQuery End
Duration = 0,25
24.11.2009 13:42:09 TOracleSession Debugger.Session Start Session.LogOn as lbs_user@VWKS_10_DEV
24.11.2009 13:42:09 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
24.11.2009 13:42:09 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
24.11.2009 13:42:09 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
24.11.2009 13:42:09 TOracleQuery Query End (1 record processed)
Duration = 0
24.11.2009 13:42:09 TOracleSession Debugger.Session End
Duration = 0,063
24.11.2009 13:42:09 SetSessionAction starts: Debug Test Window - lmfc_ipoint.tst
24.11.2009 13:42:09 TOracleQuery $09410FB0 Start Query.Execute
SQL = select null from dual
24.11.2009 13:42:09 TOracleQuery $09410FB0 End (1 record processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery $09410FB0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Debug Test Window - lmfc_ipoint.tst
24.11.2009 13:42:09 TOracleQuery $09410FB0 End
Duration = 0
24.11.2009 13:42:09 SetSessionAction ends
24.11.2009 13:42:09 ExecuteConnectScript starts
24.11.2009 13:42:09 TOracleQuery $09410FB0 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
24.11.2009 13:42:09 TOracleQuery $09410FB0 End
Duration = 0,015
24.11.2009 13:42:09 TOracleQuery $09410FB0 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
24.11.2009 13:42:09 TOracleQuery $09410FB0 End
Duration = 0
24.11.2009 13:42:09 ExecuteConnectScript ends
24.11.2009 13:42:09 InitializeTargetSession ends
24.11.2009 13:42:09 InitStatistics starts
24.11.2009 13:42:09 TStatistics.Init starts
24.11.2009 13:42:09 InitStatNames starts
24.11.2009 13:42:09 select name from v$statname order by statistic#
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select name from v$statname order by statistic#
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.DynamicQuery End (5 records processed)
Duration = 0
24.11.2009 13:42:09 InitStatNames ends
24.11.2009 13:42:09 StatQuery.Describe starts
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.StatQuery Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.StatQuery End
Duration = 0
24.11.2009 13:42:09 StatQuery.Describe ends
24.11.2009 13:42:09 TStatistics.Init ends
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 264
24.11.2009 13:42:09 TOracleQuery PLSQLDevForm.StatQuery End (355 records processed)
Duration = 0
24.11.2009 13:42:09 InitStatistics ends
24.11.2009 13:42:09 TOracleQuery $09410FB0 Start Query.Execute
SQL = alter session set plsql_debug=true
24.11.2009 13:42:09 TOracleQuery $09410FB0 End
Duration = 0
24.11.2009 13:42:09 NavigationBookmarks.EnableButtons(Rebuild)
24.11.2009 13:42:09 NavigationBookmarks: Backward=2, Forward=0
24.11.2009 13:42:09 Debugger.Attach starts
24.11.2009 13:42:09 Debugger.SetInstance starts
24.11.2009 13:42:09 TOracleQuery $09410FB0 Start Query.Execute
SQL = alter session set instance=1
24.11.2009 13:42:09 TOracleQuery $09410FB0 End
Duration = 0
24.11.2009 13:42:09 Debugger.SetInstance ends
24.11.2009 13:42:09 TOracleQuery Debugger.AttachQuery Start Query.Execute
SQL = declare
runtime_info sys.dbms_debug.runtime_info;
begin
sys.dbms_debug.default_timeout := :default_timeout;
runtime_info.program.namespace := null;
runtime_info.program.name := null;
runtime_info.program.owner := null;
runtime_info.program.dblink := null;
runtime_info.line# := null;
runtime_info.terminated := null;
runtime_info.breakpoint := null;
runtime_info.stackdepth := null;
runtime_info.interpreterdepth := null;
runtime_info.reason := null;
sys.dbms_debug.attach_session(debug_session_id => :debug_session_id);
:sync_result := sys.dbms_debug.synchronize(run_info => runtime_info,
info_requested => sys.dbms_debug.info_getStackDepth +
sys.dbms_debug.info_getLineInfo +
sys.dbms_debug.info_getBreakpoint);
:program_namespace := runtime_info.program.namespace;
:program_name := runtime_info.program.name;
:program_owner := runtime_info.program.owner;
:program_dblink := runtime_info.program.dblink;
:line# := runtime_info.line#;
:terminated := runtime_info.terminated;
:breakpoint := runtime_info.breakpoint;
:stackdepth := runtime_info.stackdepth;
:interpreterdepth := runtime_info.interpreterdepth;
:reason := runtime_info.reason;
sys.dbms_debug.default_timeout := 3600;
end;
:DEBUG_SESSION_ID = 010820570001
:PROGRAM_NAMESPACE = Null
:PROGRAM_NAME = Null
:PROGRAM_OWNER = Null
:PROGRAM_DBLINK = Null
:LINE# = Null
:TERMINATED = Null
:BREAKPOINT = Null
:STACKDEPTH = Null
:INTERPRETERDEPTH = Null
:REASON = Null
:SYNC_RESULT = Null
:DEFAULT_TIMEOUT = 10
24.11.2009 13:42:09 TSQLThread SQLThread.Execute
24.11.2009 13:42:09 TOracleQuery TestForm.TestQuery Start Query.Execute
SQL = declare
begin
-- 1 2 3 4
-- 01234567890123456789012345678901234567890123456789
-- _errorMask = ' 1
insert into hbrech_log values ('-I- start of lmfc_ipoint', dbms_utility.format_call_stack, sysdate);
:tmpErrorMask := lbs_c.LBS_STRING_DEFAULT;
:tmpErrorMask := lmfc_fnct.LMFC_fnctErrorMaskBitSet (i_LMFCTUE_errorMask => :tmpErrorMask,
i_bitValue => lbs_conv.lbs_convStringToNumber (:i_errorSpsOverWeight),
i_bitNo => 41);
:tmpErrorMask := lmfc_fnct.LMFC_fnctErrorMaskBitSet (i_LMFCTUE_errorMask => :tmpErrorMask,
i_bitValue => lbs_conv.lbs_convStringToNumber (:i_errorLvrNoData),
i_bitNo => 42);
:tmpErrorMask := lmfc_fnct.LMFC_fnctErrorMaskBitSet (i_LMFCTUE_errorMask => :tmpErrorMask,
i_bitValue => lbs_conv.lbs_convStringToNumber (:i_errorLvrWeightDiscr),
i_bitNo => 43);
:tmpErrorMask := lmfc_fnct.LMFC_fnctErrorMaskBitSet (i_LMFCTUE_errorMask => :tmpErrorMask,
i_bitValue => lbs_conv.lbs_convStringToNumber (:i_errorSpsOverHeight),
i_bitNo => 44);
:tmpErrorMask := lmfc_fnct.LMFC_fnctErrorMaskBitSet (i_LMFCTUE_errorMask => :tmpErrorMask,
i_bitValue => lbs_conv.lbs_convStringToNumber (:i_errorLvrNoEmptyTu),
i_bitNo => 48);

:o_retCode := lbs_c.LBS_SP_OK;
:o_retInfo := lbs_c.LBS_STRING_DEFAULT;

if (lbs_fnct.lbs_fnctCallIsOk (:o_retCode) = lbs_c.LBS_TRUE) then
insert into hbrech_log values ('-I- lmfc_apexecstateset', dbms_utility.format_call_stack, sysdate);
lmfc_apexecstateset.lmfc_apexecstateset(i_userno => :i_userno,
i_coord => :i_coord,
i_tuident => :i_tuident,
i_nveno => ' ',
i_turef => 0,
i_execstate => lmfc_c.LMFC_LOC_EXECSTATE_INIT,
o_retcode => :o_retcode,
o_retinfo => :o_retinfo);
end if;

if (lbs_fnct.lbs_fnctCallIsOk (:o_retCode) = lbs_c.LBS_TRUE) then
insert into hbrech_log values ('-I- lmfc_aptuappeared', dbms_utility.format_call_stack, sysdate);
lmfc_aptuappeared.lmfc_aptuappeared(i_userno => :i_userno,
i_coord => :i_coord,
i_tuident => :i_tuident,
i_nveno => ' ',
i_turef => 0,
i_typetu => ' ',
i_typeload => ' ',
i_actionident => ' ',
o_retcode => :o_retcode,
o_retinfo => :o_retinfo);
end if;

if (lbs_fnct.lbs_fnctCallIsOk (:o_retCode) = lbs_c.LBS_TRUE) then
--#define MFCI_TU_ERR_OVERWEIGHT 41 /*
 
You must log in or register to reply here.

Similar threads

L
  • Discussion Discussion
PLSQL Developer app is freezing
Replies
5
Views
7K
Marco Kalter
Marco Kalter
S
  • Discussion Discussion
PLSQL Developer 13 - Window List issue
Replies
2
Views
2K
Sztefi
S
C
  • Discussion Discussion
Recovery not working
Replies
11
Views
36K
Natalen
N
Basti
  • Discussion Discussion
Debugging a running (web-)application
Replies
4
Views
785
Basti
Basti
B
  • Discussion Discussion
Transferrinf from Toad to PL/SQL developer and struggling with tasks
Replies
4
Views
1K
Boydy
B
Back
Top