Getting "Access violation at address 61DEF440 in module 'OraClient10.dll"

V

Vinayak

Member
Hi,

I am getting the following error while trying to view the result set through a cursor returned by a procedure in the test window.
Here is the output of the debug.txt file:

PL/SQL Developer
Version 7.1.5.1398
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 2,094,632 kB (525,992 available)
Paging file : 4,036,696 kB (2,430,292 available)
Virtual memory : 2,097,024 kB (2,027,256 available)

Parameters
C:\PLSQLDeveloper\plsqldev.exe
debugsql

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

Preference Files

Plug-Ins

14/01/2009 06:08:59 PM Application started
14/01/2009 06:08:59 PM InitPreferences
14/01/2009 06:08:59 PM Load C:\PLSQLDeveloper\Preferences\Default = 0
14/01/2009 06:08:59 PM PreferenceSet.Load C:\PLSQLDeveloper\Preferences\Default\Default.ini
14/01/2009 06:08:59 PM PreferenceSet.Load OK
14/01/2009 06:08:59 PM Determine LocalPrefPath
14/01/2009 06:08:59 PM [1]: C:\Documents and Settings\awasthvi\Application Data\PLSQL Developer\Preferences
14/01/2009 06:08:59 PM LocalPrefPath: C:\Documents and Settings\awasthvi\Application Data\PLSQL Developer\Preferences\awasthvi
14/01/2009 06:08:59 PM Load C:\Documents and Settings\awasthvi\Application Data\PLSQL Developer\Preferences\awasthvi = 0
14/01/2009 06:08:59 PM PreferenceSet.Load C:\Documents and Settings\awasthvi\Application Data\PLSQL Developer\Preferences\awasthvi\default.ini
14/01/2009 06:08:59 PM PreferenceSet.Load OK
14/01/2009 06:08:59 PM PreferenceSet.Load C:\Documents and Settings\awasthvi\Application Data\PLSQL Developer\Preferences\awasthvi\user.prefs
14/01/2009 06:08:59 PM PreferenceSet.Load OK
14/01/2009 06:08:59 PM InitPreferences end
14/01/2009 06:08:59 PM SortPreferenceSets
14/01/2009 06:08:59 PM - Default awasthvi
14/01/2009 06:08:59 PM - System Default
14/01/2009 06:09:00 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
14/01/2009 06:09:00 PM ReadString OK
14/01/2009 06:09:00 PM pfReadRegistry: "C:\PLSQLDeveloper\PlSqlDev.exe" "%1"
14/01/2009 06:09:00 PM LoadPreferences
14/01/2009 06:09:00 PM LoadPreferences searching for default
14/01/2009 06:09:00 PM C:\Documents and Settings\awasthvi\Application Data\PLSQL Developer\Preferences\awasthvi\default.ini
14/01/2009 06:09:00 PM LoadPreferences NewPref := nil
14/01/2009 06:09:00 PM LoadPreferences
14/01/2009 06:09:00 PM LoadPreferences Reading preferences
14/01/2009 06:09:00 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
14/01/2009 06:09:00 PM ReadString OK
14/01/2009 06:09:00 PM pfReadRegistry: "C:\PLSQLDeveloper\PlSqlDev.exe" "%1"
14/01/2009 06:09:00 PM LoadPreferences ReadPosition
14/01/2009 06:09:00 PM LoadPreferences ToolsBrowserItemClick(nil)
14/01/2009 06:09:00 PM LoadPreferences CreateBrowserFilters...
14/01/2009 06:09:00 PM LoadPreferences Files
14/01/2009 06:09:00 PM LoadPreferences Logon
14/01/2009 06:09:00 PM LoadPreferences Buttons
14/01/2009 06:09:00 PM LoadPreferences Printer
14/01/2009 06:09:00 PM LoadPreferences BrowserFolders
14/01/2009 06:09:00 PM LoadPreferences
14/01/2009 06:09:00 PM LoadPreferences end
14/01/2009 06:09:00 PM MacroLibFilename: C:\PLSQLDeveloper\Macro\awasthvi.lib
14/01/2009 06:09:03 PM TOracleSession PLSQLDevForm.Session Start Session.LogOn as irp_dbo@ibarpd02.world
14/01/2009 06:09:04 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
14/01/2009 06:09:04 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
14/01/2009 06:09:04 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
14/01/2009 06:09:04 PM TOracleQuery Query End (1 record processed)
Duration = 0.016
14/01/2009 06:09:04 PM TOracleSession PLSQLDevForm.Session End
Duration = 0.719
14/01/2009 06:09:04 PM LogonHistorySave start
14/01/2009 06:09:04 PM ChangeUserPref LogonHistory,
14/01/2009 06:09:04 PM ChangeUserPref DSA,
14/01/2009 06:09:04 PM ChangeUserPref end
14/01/2009 06:09:04 PM ChangeUserPref ColumnAssociations,
14/01/2009 06:09:04 PM ChangeUserPref end
14/01/2009 06:09:04 PM ChangeUserPref ImportAssociations,
14/01/2009 06:09:04 PM ChangeUserPref end
14/01/2009 06:09:04 PM ChangeUserPref BrowserFilters,
14/01/2009 06:09:04 PM ChangeUserPref end
14/01/2009 06:09:04 PM ChangeUserPref BrowserFolders,
14/01/2009 06:09:04 PM ChangeUserPref end
14/01/2009 06:09:04 PM ChangeUserPref SessionQueries,
14/01/2009 06:09:04 PM ChangeUserPref end
14/01/2009 06:09:04 PM ChangeUserPref ExternalTools,
14/01/2009 06:09:04 PM ChangeUserPref end
14/01/2009 06:09:04 PM ChangeUserPref Documents,
14/01/2009 06:09:04 PM ChangeUserPref end
14/01/2009 06:09:04 PM ChangeUserPref Reports,
14/01/2009 06:09:04 PM ChangeUserPref end
14/01/2009 06:09:04 PM LogonHistorySave end
14/01/2009 06:09:04 PM FormCreate Session.Connected
14/01/2009 06:09:04 PM FormCreate Logon.Executed -1
14/01/2009 06:09:04 PM FormCreate TDBNames.Make
14/01/2009 06:09:04 PM FormCreate SessionChanged
14/01/2009 06:09:04 PM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
14/01/2009 06:09:04 PM TOracleQuery Query End (5 records processed)
Duration = 0
14/01/2009 06:09:04 PM SessionChanged SetDBAViews
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 End (0 records processed)
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 End (0 records processed)
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0.015
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0.016
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0.016
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
14/01/2009 06:09:04 PM TOracleQuery PLSQLDevForm.DynamicQuery End (33 records processed)
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 Start Query.Describe
SQL = select * from sys.dba_objects where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 Start Query.Describe
SQL = select * from sys.dba_tab_columns where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 End
Duration = 0.015
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 Start Query.Describe
SQL = select * from sys.dba_col_comments where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 Start Query.Describe
SQL = select * from sys.dba_triggers where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 Start Query.Describe
SQL = select * from sys.dba_constraints where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 Start Query.Describe
SQL = select * from sys.dba_indexes where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 End
Duration = 0.016
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 Start Query.Describe
SQL = select * from sys.dba_cons_columns where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_ind_columns where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_dependencies where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 Start Query.Describe
SQL = select * from sys.dba_tables where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 Start Query.Describe
SQL = select * from sys.dba_tab_comments where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 Start Query.Describe
SQL = select * from sys.dba_sequences where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AB01C0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_errors where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0.015
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_source where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_views where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_synonyms where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0.016
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_users where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_object_tables where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_type_attrs where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_type_methods where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_method_params where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_method_results where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_tab_privs where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0.016
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_clusters where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_libraries where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_directories where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_jobs where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_db_links where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_mviews where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0.015
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_snapshots where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_queues where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_queue_tables where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0.016
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 Start Query.Describe
SQL = select * from sys.dba_types where rownum < 1
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Duration = 0
14/01/2009 06:09:04 PM SessionChanged Authorizations.Load
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 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)
14/01/2009 06:09:04 PM TOracleQuery $02AAFDA0 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
14/01/2009 06:09:04 PM SessionChanged EnableAuthorizedMenus
14/01/2009 06:09:04 PM TOracleSession $033BEB10 Start Session.LogOn as irp_dbo@ibarpd02.world
14/01/2009 06:09:05 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
14/01/2009 06:09:05 PM TOracleQuery Query End (1 record processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleSession $033BEB10 End
Duration = 0.594
14/01/2009 06:09:05 PM SetSessionAction starts: Main session
14/01/2009 06:09:05 PM TOracleQuery $02AAFC40 Start Query.Execute
SQL = select null from dual
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 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')
14/01/2009 06:09:05 PM TOracleQuery $02AAFC40 End (1 record processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AAFC40 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
14/01/2009 06:09:05 PM TOracleQuery $02AAFC40 End
Duration = 0.015
14/01/2009 06:09:05 PM SetSessionAction ends
14/01/2009 06:09:05 PM ExecuteConnectScript starts
14/01/2009 06:09:05 PM ExecuteConnectScript ends
14/01/2009 06:09:05 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.015
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM SessionChanged LoadRecentObjects
14/01/2009 06:09:05 PM SessionChanged Notify children
14/01/2009 06:09:05 PM SessionChanged Logoff secondary sessions
14/01/2009 06:09:05 PM SessionChanged SessionMode = smMulti
14/01/2009 06:09:05 PM SessionChanged EnableChildFunctions
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.015
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraDb10g_home1
OracleHomeDir: C:\Oracle10g\product\10.2.0\db_1
Found: oci.dll
Using: C:\Oracle10g\product\10.2.0\db_1\bin\oci.dll
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.078
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.015
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.062
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.015
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.015
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.031
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:05 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:06 PM SortPreferenceSets
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.015
14/01/2009 06:09:06 PM - Default awasthvi
14/01/2009 06:09:06 PM - System Default
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.015
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:06 PM TOracleQuery $02AAFC40 Start Query.Execute
SQL = select null from all_synonyms where 1=0
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 End (30 records processed)
Duration = 0
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 Start Query.Execute
SQL = select s.synonym_name object_name, o.object_type
from sys.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')
14/01/2009 06:09:06 PM TOracleQuery $02AAFC40 End (0 records processed)
Duration = 0
14/01/2009 06:09:06 PM TOracleQuery $02AAFC40 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
14/01/2009 06:09:06 PM TOracleQuery $02AAFC40 End (0 records processed)
Duration = 0
14/01/2009 06:09:06 PM WMUpdatePopups starts
14/01/2009 06:09:06 PM GetCrashList: 28312574.cfg
14/01/2009 06:09:06 PM LoadDesktop starts
14/01/2009 06:09:06 PM LoadDesktop ends
14/01/2009 06:09:06 PM WMUpdatePopups ends
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.813
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.015
14/01/2009 06:09:06 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.141
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.093
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.032
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.015
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.047
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.031
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.047
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.047
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.047
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.031
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.047
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.031
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.016
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.047
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.047
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.046
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (100 records processed)
Duration = 0.031
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 Start Query.Next for up to 100 records
14/01/2009 06:09:07 PM TOracleQuery $02AB0060 End (14 records processed)
Duration = 0
14/01/2009 06:09:07 PM TOracleSession $033BEB10 Start Session.LogOff
14/01/2009 06:09:07 PM TOracleSession $033BEB10 End
Duration = 0.016
14/01/2009 06:09:13 PM Create TTestForm Start
14/01/2009 06:09:13 PM Create TTestForm Inherited
14/01/2009 06:09:13 PM Create TTestForm SetupMainFont
14/01/2009 06:09:13 PM Create TTestForm Activate
14/01/2009 06:09:13 PM Create TTestForm Activate done
14/01/2009 06:09:13 PM Create TTestForm UpdateWindowList
14/01/2009 06:09:13 PM Create TTestForm Positioning
14/01/2009 06:09:13 PM Create TTestForm Finished
14/01/2009 06:09:13 PM NavigationBookmarks.EnableButtons(Rebuild)
14/01/2009 06:09:13 PM NavigationBookmarks: Backward=0, Forward=0
14/01/2009 06:09:59 PM TOracleQuery $02AAF980 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:09:59 PM TOracleQuery $02AAF980 End (1 record processed)
Duration = 0
14/01/2009 06:10:09 PM SetConnected starts
14/01/2009 06:10:09 PM SetConnected: Connect starts
14/01/2009 06:10:09 PM TOracleSession $033C3C70 Start Session.LogOn as irp_dbo@ibarpd02.world
14/01/2009 06:10:09 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
14/01/2009 06:10:09 PM TOracleQuery Query End (1 record processed)
Duration = 0.015
14/01/2009 06:10:09 PM TOracleSession $033C3C70 End
Duration = 0.562
14/01/2009 06:10:09 PM SetConnected: (Dis)connect ends
14/01/2009 06:10:09 PM SetSessionAction starts: Test Window - New
14/01/2009 06:10:09 PM TOracleQuery $02AAF820 Start Query.Execute
SQL = select null from dual
14/01/2009 06:10:09 PM TOracleQuery $02AAF820 End (1 record processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
14/01/2009 06:10:09 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
14/01/2009 06:10:09 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.016
14/01/2009 06:10:09 PM TOracleQuery $02AAF820 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Test Window - New
14/01/2009 06:10:09 PM TOracleQuery $02AAF820 End
Duration = 0
14/01/2009 06:10:09 PM SetSessionAction ends
14/01/2009 06:10:09 PM ExecuteConnectScript starts
14/01/2009 06:10:09 PM ExecuteConnectScript ends
14/01/2009 06:10:09 PM TOracleQuery $02AAF820 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
14/01/2009 06:10:09 PM TOracleQuery $02AAF820 End (1 record processed)
Duration = 0
14/01/2009 06:10:09 PM InitHTPOutput starts
14/01/2009 06:10:09 PM TOracleQuery $02AAF820 Start Query.Execute
SQL = begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
14/01/2009 06:10:09 PM TOracleQuery $02AAF820 End
Duration = 0.016
14/01/2009 06:10:09 PM InitHTPOutput finished
14/01/2009 06:10:09 PM EnableOutput starts
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.EnableOutputQuery Start Query.Execute
SQL = begin
if :enable = 0 then
sys.dbms_output.disable;
else
sys.dbms_output.enable(:size);
end if;
end;
:ENABLE = 1
:SIZE = 10000
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
14/01/2009 06:10:09 PM EnableOutput done
14/01/2009 06:10:09 PM InitStatistics starts
14/01/2009 06:10:09 PM TStatistics.Init starts
14/01/2009 06:10:09 PM InitStatNames starts
14/01/2009 06:10:09 PM select name from v$statname order by statistic#
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select name from v$statname order by statistic#
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.015
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.016
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.016
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.DynamicQuery End (3 records processed)
Duration = 0
14/01/2009 06:10:09 PM InitStatNames ends
14/01/2009 06:10:09 PM StatQuery.Describe starts
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.StatQuery Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.StatQuery End
Duration = 0
14/01/2009 06:10:09 PM StatQuery.Describe ends
14/01/2009 06:10:09 PM TStatistics.Init ends
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 338
14/01/2009 06:10:09 PM TOracleQuery PLSQLDevForm.StatQuery End (378 records processed)
Duration = 0.016
14/01/2009 06:10:09 PM InitStatistics ends
14/01/2009 06:10:09 PM NavigationBookmarks.EnableButtons(Rebuild)
14/01/2009 06:10:09 PM NavigationBookmarks: Backward=0, Forward=0
14/01/2009 06:10:09 PM TSQLThread SQLThread.Execute
14/01/2009 06:10:09 PM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
14/01/2009 06:10:09 PM TOracleQuery Query End
Duration = 0
14/01/2009 06:10:09 PM TOracleQuery TestForm.TestQuery Start Query.Execute
SQL = begin
-- Call the procedure
pk_mp_rb_batch_fpms_m09.pr_fs_team_drilldown_select(p_security_group_id => :p_security_group_id,
p_year => :p_year,
p_product_id => :p_product_id,
p_sector_id => :p_sector_id,
p_region_id => :p_region_id,
p_sponsor_id => :p_sponsor_id,
p_ubs_flag => :p_ubs_flag,
p_sort_clause => :p_sort_clause,
p_team_include => :p_team_include,
p_results => :p_results);
end;
:P_SECURITY_GROUP_ID = 1201
:P_YEAR = 2007
:P_PRODUCT_ID = -1
:P_SECTOR_ID = -1
:P_REGION_ID = -1
:P_SPONSOR_ID = -1
:P_UBS_FLAG = N
:P_SORT_CLAUSE = order by a.deal_date desc
:P_TEAM_INCLUDE = FI
:P_RESULTS = (Cursor)
14/01/2009 06:10:15 PM TOracleQuery TestForm.TestQuery End
Duration = 6.063
14/01/2009 06:10:15 PM TSQLThread SQLThread Postmessage
14/01/2009 06:10:15 PM TSQLThread SQLThread Suspend
14/01/2009 06:10:15 PM TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 338
14/01/2009 06:10:15 PM TOracleQuery PLSQLDevForm.StatQuery End (378 records processed)
Duration = 0
14/01/2009 06:10:15 PM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
14/01/2009 06:10:15 PM TOracleQuery Query End
Duration = 0
14/01/2009 06:10:15 PM NavigationBookmarks.EnableButtons(Rebuild)
14/01/2009 06:10:15 PM NavigationBookmarks: Backward=0, Forward=0
14/01/2009 06:10:15 PM TOracleQuery $02AAF6C0 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
14/01/2009 06:10:15 PM TOracleQuery $02AAF6C0 End
Duration = 0
14/01/2009 06:10:15 PM GetHTPOutput starts
14/01/2009 06:10:15 PM TOracleQuery $02AAF6C0 Start Query.Execute
SQL = begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
14/01/2009 06:10:15 PM TOracleQuery $02AAF6C0 End
Duration = 0
14/01/2009 06:10:15 PM Trying htp.get_line
14/01/2009 06:10:15 PM TOracleQuery $02AAF6C0 Start Query.Execute
SQL = begin htp.flush; :line := htp.get_line(:rows); end;
:LINE = Null
:ROWS = Null
14/01/2009 06:10:15 PM TOracleQuery $02AAF6C0 End
Duration = 0
14/01/2009 06:10:15 PM No lines retrieved
14/01/2009 06:10:15 PM GetHTPOutput finished
14/01/2009 06:10:18 PM Create TSQLForm Start
14/01/2009 06:10:18 PM Create TSQLForm Inherited
14/01/2009 06:10:18 PM TSQLForm.FormCreate Start
14/01/2009 06:10:18 PM SQLForm
14/01/2009 06:10:18 PM TSQLForm.FormCreate Finished
14/01/2009 06:10:18 PM AddNavigationBookmark starts
14/01/2009 06:10:18 PM AddNavigationBookmark GNV00001
14/01/2009 06:10:18 PM NavigationBookmarks.EnableButtons(Rebuild)
14/01/2009 06:10:18 PM NavigationBookmarks: Backward=1, Forward=0
14/01/2009 06:10:18 PM AddNavigationBookmark ends
14/01/2009 06:10:18 PM Create TSQLForm SetupMainFont
14/01/2009 06:10:18 PM Create TSQLForm Activate
14/01/2009 06:10:18 PM Create TSQLForm Activate done
14/01/2009 06:10:18 PM Create TSQLForm UpdateWindowList
14/01/2009 06:10:18 PM Create TSQLForm Positioning
14/01/2009 06:10:18 PM Create TSQLForm Finished
14/01/2009 06:10:18 PM SQLForm Initializing...
14/01/2009 06:10:18 PM NavigationBookmarks.EnableButtons(Rebuild)
14/01/2009 06:10:18 PM NavigationBookmarks: Backward=1, Forward=0
14/01/2009 06:10:18 PM SQLForm Executing...
14/01/2009 06:10:18 PM SQLForm Executing...
14/01/2009 06:10:18 PM TSQLThread SQLThread.Execute
14/01/2009 06:10:18 PM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
14/01/2009 06:10:18 PM TOracleQuery Query End
Duration = 0
14/01/2009 06:10:18 PM TOracleQuery $02AAF820 Start Query.Execute
14/01/2009 06:10:18 PM TOracleQuery $02AAF820 End
Result = Access violation at address 61DEF440 in module 'OraClient10.Dll'. Read of address 00000000
Duration = 0.063
14/01/2009 06:10:18 PM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
14/01/2009 06:10:18 PM TOracleQuery Query End
Duration = 0
14/01/2009 06:10:18 PM TSQLThread SQLThread Postmessage
14/01/2009 06:10:18 PM TSQLThread SQLThread Suspend
14/01/2009 06:10:18 PM TSQLForm.ThreadFinished
14/01/2009 06:10:18 PM TSQLForm.ThreadFinished: SQLThread.Suspended
14/01/2009 06:10:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:10:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:11:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:11:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:12:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:12:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:13:46 PM NavigationBookmarks.EnableButtons(Rebuild)
14/01/2009 06:13:46 PM NavigationBookmarks: Backward=1, Forward=0
14/01/2009 06:13:46 PM SQLForm Access violation at address 61DEF440 in module 'OraClient10.Dll'. Read of address 00000000
14/01/2009 06:13:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:13:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:14:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:14:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:15:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:15:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:16:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:16:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:17:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:17:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:18:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:18:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:19:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:19:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:20:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:20:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:21:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:21:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:22:59 PM TOracleQuery $02AAEFE0 Start Query.Execute
SQL = select 'x' from dual
14/01/2009 06:22:59 PM TOracleQuery $02AAEFE0 End (1 record processed)
Duration = 0
14/01/2009 06:23:27 PM Destroying TSQLForm

Please can someone have a look.
 
I cannot reproduce this. Does this error also occur for a simple script like this?

Code: 
begin
  open :dual_cursor for select * from dual;
end;
 
Hi Marco,

It didn't occured for the above code. Even in 90% of my cases it worked. Say if I have a procedure which returns 4 cursors as OUT variables, out of 4, 3 will perfectly give the result while the last one will fail with the above mentioned error. Though all the 4 cursors are similar and return same sort of columns.

In my current issue, the procedure has just 1 OUT cursor and that banged out with the memory error.

Thanks
Vinayak
 
You must log in or register to reply here.

Similar threads

R
  • Discussion Discussion
Very slow closing all windows
Replies
8
Views
7K
Marco Kalter
Marco Kalter
J
  • Discussion Discussion
ORA-03114 Import PDE
Replies
2
Views
2K
Marco Kalter
Marco Kalter
C
  • Discussion Discussion
EOutOfMemory Error
Replies
1
Views
1K
Marco Kalter
Marco Kalter
M
  • Discussion Discussion
Bug - Roles in Object Browser
Replies
1
Views
3K
Marco Kalter
Marco Kalter
F
  • Discussion Discussion
Check connection vs. Check connections
Replies
1
Views
3K
Marco Kalter
Marco Kalter
Back
Top