Print Thread
Error message by selecting data over an Oracle gateway
#38694 09/06/10 11:39 AM
Joined: Sep 2010
Posts: 6
O
Member
OP Offline
Member
O
Joined: Sep 2010
Posts: 6
Hello

I get the following error message when I try to select data from MS SQL Server 2008 over an Oracle 11.2.0.1 Gateway

I make a
[quote]select * from table@gateway [/quote]
I get
ORA-00600: Internal errorcode, arguments:[HO define: Long fetch], [], [], [], [], [], [], []

but if i make a

[quote]select column1, column2, .... column10 from table@gateway [/quote]
it works without errors

When I make the same things on the command line with sqlplus, everything works fine

Is there a solution for this problem ?

Windows XP 32bit SP3
PL/SQL Developer 8.0.4.1514

Last edited by overall7k; 09/06/10 11:40 AM.
Re: Error message by selecting data over an Oracle gateway
overall7k #38697 09/07/10 09:04 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

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

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\<User>\AppData\Roaming\PLSQL Developer).


Marco Kalter
Allround Automations
Re: Error message by selecting data over an Oracle gateway
Marco Kalter #38698 09/07/10 10:56 AM
Joined: Sep 2010
Posts: 6
O
Member
OP Offline
Member
O
Joined: Sep 2010
Posts: 6
Ok here is the debug.txt

[quote]
PL/SQL Developer
Version 8.0.4.1514
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

Physical memory : 2.088.432 kB (1.329.024 available)
Paging file : 4.029.496 kB (2.795.184 available)
Virtual memory : 2.097.024 kB (2.033.532 available)

Parameters
C:\Program Files\PLSQL Developer\PlSqlDev.exe
DebugSQL

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

Preference Files

Plug-Ins

07.09.2010 11:41:37 Application started
07.09.2010 11:41:37 InitPreferences
07.09.2010 11:41:37 Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
07.09.2010 11:41:37 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
07.09.2010 11:41:37 PreferenceSet.Load OK
07.09.2010 11:41:37 Determine LocalPrefPath
07.09.2010 11:41:37 [1]: C:\Program Files\PLSQL Developer\Preferences
07.09.2010 11:41:37 LocalPrefPath: C:\Program Files\PLSQL Developer\Preferences\vietsi
07.09.2010 11:41:37 Load C:\Program Files\PLSQL Developer\Preferences\vietsi = 0
07.09.2010 11:41:37 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\vietsi\default.ini
07.09.2010 11:41:37 PreferenceSet.Load OK
07.09.2010 11:41:37 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\vietsi\user.prefs
07.09.2010 11:41:37 PreferenceSet.Load OK
07.09.2010 11:41:37 InitPreferences end
07.09.2010 11:41:37 SortPreferenceSets
07.09.2010 11:41:37 - Default vietsi
07.09.2010 11:41:37 - System Default
07.09.2010 11:41:37 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
07.09.2010 11:41:37 ReadString OK
07.09.2010 11:41:37 pfReadRegistry: "c:\program files\plsql developer\PLSQLDev.exe" "%1"
07.09.2010 11:41:38 LoadPreferences
07.09.2010 11:41:38 LoadPreferences searching for default
07.09.2010 11:41:38 C:\Program Files\PLSQL Developer\Preferences\vietsi\default.ini
07.09.2010 11:41:38 LoadPreferences NewPref := nil
07.09.2010 11:41:38 LoadPreferences <section 2>
07.09.2010 11:41:38 LoadPreferences Reading preferences
07.09.2010 11:41:38 LoadPreferences ReadPosition
07.09.2010 11:41:38 LoadPreferences ToolsBrowserItemClick(nil)
07.09.2010 11:41:38 LoadPreferences CreateBrowserFilters...
07.09.2010 11:41:38 LoadPreferences Files
07.09.2010 11:41:38 LoadPreferences Logon
07.09.2010 11:41:38 LoadPreferences Buttons
07.09.2010 11:41:38 LoadPreferences Printer
07.09.2010 11:41:38 LoadPreferences FileBrowserFolders
07.09.2010 11:41:38 LoadPreferences BrowserFolders
07.09.2010 11:41:38 LoadPreferences <section 3>
07.09.2010 11:41:38 LoadPreferences end
07.09.2010 11:41:38 MacroLibFilename: C:\Program Files\PLSQL Developer\Macro\vietsi.lib
07.09.2010 11:41:38 FormCreate Logon.Execute
07.09.2010 11:41:40 TOracleSession PLSQLDevForm.Session Start Session.LogOn as mmwh@VTBTEST.world
07.09.2010 11:41:46 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
07.09.2010 11:41:46 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0,016
07.09.2010 11:41:46 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
07.09.2010 11:41:46 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0,015
07.09.2010 11:41:46 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
07.09.2010 11:41:46 TOracleQuery Query End (1 record processed)
Duration = 0
07.09.2010 11:41:46 TOracleSession PLSQLDevForm.Session End
Duration = 5,828
07.09.2010 11:41:46 LogonHistorySave start
07.09.2010 11:41:46 ChangeUserPref LogonHistory,
07.09.2010 11:41:46 ChangeUserPref DSA,
07.09.2010 11:41:46 ChangeUserPref end
07.09.2010 11:41:46 ChangeUserPref ColumnAssociations,
07.09.2010 11:41:46 ChangeUserPref end
07.09.2010 11:41:46 ChangeUserPref ImportAssociations,
07.09.2010 11:41:46 ChangeUserPref end
07.09.2010 11:41:46 ChangeUserPref BrowserFilters,
07.09.2010 11:41:46 ChangeUserPref end
07.09.2010 11:41:46 ChangeUserPref FileBrowserFolders,
07.09.2010 11:41:46 ChangeUserPref end
07.09.2010 11:41:46 ChangeUserPref BrowserFolders,
07.09.2010 11:41:46 ChangeUserPref end
07.09.2010 11:41:46 ChangeUserPref SessionQueries,
07.09.2010 11:41:46 ChangeUserPref end
07.09.2010 11:41:46 ChangeUserPref ExternalTools,
07.09.2010 11:41:46 ChangeUserPref end
07.09.2010 11:41:46 ChangeUserPref Documents,
07.09.2010 11:41:46 ChangeUserPref end
07.09.2010 11:41:46 ChangeUserPref Reports,
07.09.2010 11:41:46 ChangeUserPref end
07.09.2010 11:41:46 LogonHistorySave end
07.09.2010 11:41:46 FormCreate Session.Connected
07.09.2010 11:41:46 FormCreate Logon.Executed -1
07.09.2010 11:41:46 FormCreate TDBNames.Make
07.09.2010 11:41:46 FormCreate SessionChanged
07.09.2010 11:41:46 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
07.09.2010 11:41:46 TOracleQuery Query End (5 records processed)
Duration = 0
07.09.2010 11:41:46 SessionChanged SetDBAViews
07.09.2010 11:41:46 TOracleQuery $02B9D120 Start Query.Execute
SQL = select null from all_synonyms where 1=0
07.09.2010 11:41:46 TOracleQuery $02B9D120 End (0 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery $02B9D120 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
07.09.2010 11:41:46 TOracleQuery $02B9D120 End (0 records processed)
Duration = 0,015
07.09.2010 11:41:46 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%'
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,032
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0,016
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
07.09.2010 11:41:46 TOracleQuery PLSQLDevForm.DynamicQuery End (22 records processed)
Duration = 0
07.09.2010 11:41:46 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_objects where rownum < 1
07.09.2010 11:41:46 TOracleQuery $02B9D120 End
Duration = 0,062
07.09.2010 11:41:46 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_tab_columns where rownum < 1
07.09.2010 11:41:47 TOracleQuery $02B9D120 End
Duration = 0,438
07.09.2010 11:41:47 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_col_comments where rownum < 1
07.09.2010 11:41:47 TOracleQuery $02B9D120 End
Duration = 0,187
07.09.2010 11:41:47 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_triggers where rownum < 1
07.09.2010 11:41:48 TOracleQuery $02B9D120 End
Duration = 0,75
07.09.2010 11:41:48 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_constraints where rownum < 1
07.09.2010 11:41:50 TOracleQuery $02B9D120 End
Duration = 2,188
07.09.2010 11:41:50 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_indexes where rownum < 1
07.09.2010 11:41:50 TOracleQuery $02B9D120 End
Duration = 0,156
07.09.2010 11:41:50 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_cons_columns where rownum < 1
07.09.2010 11:41:50 TOracleQuery $02B9D120 End
Duration = 0,266
07.09.2010 11:41:50 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_ind_columns where rownum < 1
07.09.2010 11:41:51 TOracleQuery $02B9D120 End
Duration = 0,187
07.09.2010 11:41:51 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_dependencies where rownum < 1
07.09.2010 11:41:51 TOracleQuery $02B9D120 End
Duration = 0,25
07.09.2010 11:41:51 TOracleQuery $02B9CFC0 Start Query.Describe
SQL = select * from sys.dba_tables where rownum < 1
07.09.2010 11:41:51 TOracleQuery $02B9CFC0 End
Duration = 0,125
07.09.2010 11:41:51 TOracleQuery $02B9CFC0 Start Query.Describe
SQL = select * from sys.dba_tab_comments where rownum < 1
07.09.2010 11:41:51 TOracleQuery $02B9CFC0 End
Duration = 0,047
07.09.2010 11:41:51 TOracleQuery $02B9CFC0 Start Query.Describe
SQL = select * from sys.dba_sequences where rownum < 1
07.09.2010 11:41:51 TOracleQuery $02B9CFC0 End
Duration = 0,031
07.09.2010 11:41:51 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_errors where rownum < 1
07.09.2010 11:41:51 TOracleQuery $02B9D120 End
Duration = 0,125
07.09.2010 11:41:51 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_source where rownum < 1
07.09.2010 11:41:51 TOracleQuery $02B9D120 End
Duration = 0,188
07.09.2010 11:41:51 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_views where rownum < 1
07.09.2010 11:41:52 TOracleQuery $02B9D120 End
Duration = 0,156
07.09.2010 11:41:52 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_synonyms where rownum < 1
07.09.2010 11:41:52 TOracleQuery $02B9D120 End
Duration = 0,079
07.09.2010 11:41:52 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_users where rownum < 1
07.09.2010 11:41:52 TOracleQuery $02B9D120 End
Duration = 0,14
07.09.2010 11:41:52 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_object_tables where rownum < 1
07.09.2010 11:41:52 TOracleQuery $02B9D120 End
Duration = 0,578
07.09.2010 11:41:52 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_type_attrs where rownum < 1
07.09.2010 11:41:54 TOracleQuery $02B9D120 End
Duration = 1,094
07.09.2010 11:41:54 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_type_methods where rownum < 1
07.09.2010 11:41:54 TOracleQuery $02B9D120 End
Duration = 0,156
07.09.2010 11:41:54 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_method_params where rownum < 1
07.09.2010 11:41:54 TOracleQuery $02B9D120 End
Duration = 0,531
07.09.2010 11:41:54 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_method_results where rownum < 1
07.09.2010 11:41:55 TOracleQuery $02B9D120 End
Duration = 1
07.09.2010 11:41:55 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_tab_privs where rownum < 1
07.09.2010 11:41:55 TOracleQuery $02B9D120 End
Duration = 0,188
07.09.2010 11:41:55 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_clusters where rownum < 1
07.09.2010 11:41:55 TOracleQuery $02B9D120 End
Duration = 0,062
07.09.2010 11:41:55 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_libraries where rownum < 1
07.09.2010 11:41:56 TOracleQuery $02B9D120 End
Duration = 0,188
07.09.2010 11:41:56 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_directories where rownum < 1
07.09.2010 11:41:56 TOracleQuery $02B9D120 End
Duration = 0,078
07.09.2010 11:41:56 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_jobs where rownum < 1
07.09.2010 11:41:56 TOracleQuery $02B9D120 End
Duration = 0,079
07.09.2010 11:41:56 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_db_links where rownum < 1
07.09.2010 11:41:56 TOracleQuery $02B9D120 End
Duration = 0
07.09.2010 11:41:56 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_mviews where rownum < 1
07.09.2010 11:41:56 TOracleQuery $02B9D120 End
Duration = 0,14
07.09.2010 11:41:56 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_snapshots where rownum < 1
07.09.2010 11:41:56 TOracleQuery $02B9D120 End
Duration = 0,094
07.09.2010 11:41:56 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_queues where rownum < 1
07.09.2010 11:41:56 TOracleQuery $02B9D120 End
Duration = 0,187
07.09.2010 11:41:56 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_queue_tables where rownum < 1
07.09.2010 11:41:56 TOracleQuery $02B9D120 End
Duration = 0,047
07.09.2010 11:41:56 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_types where rownum < 1
07.09.2010 11:41:57 TOracleQuery $02B9D120 End
Duration = 0,875
07.09.2010 11:41:57 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_scheduler_jobs where rownum < 1
07.09.2010 11:41:58 TOracleQuery $02B9D120 End
Duration = 0,688
07.09.2010 11:41:58 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_scheduler_program_args where rownum < 1
07.09.2010 11:41:58 TOracleQuery $02B9D120 End
Duration = 0,562
07.09.2010 11:41:58 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_scheduler_job_args where rownum < 1
07.09.2010 11:41:58 TOracleQuery $02B9D120 End
Duration = 0,078
07.09.2010 11:41:58 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_scheduler_wingroup_members where rownum < 1
07.09.2010 11:41:59 TOracleQuery $02B9D120 End
Duration = 0,063
07.09.2010 11:41:59 TOracleQuery $02B9D120 Start Query.Describe
SQL = select * from sys.dba_scheduler_windows where rownum < 1
07.09.2010 11:41:59 TOracleQuery $02B9D120 End
Duration = 0,031
07.09.2010 11:41:59 SessionChanged Authorizations.Load
07.09.2010 11:41:59 TOracleQuery $02B9D120 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)
07.09.2010 11:41:59 TOracleQuery $02B9D120 End
Result = ORA-00942: Tabelle oder View nicht vorhanden
Duration = 0,015
07.09.2010 11:41:59 SessionChanged EnableAuthorizedMenus
07.09.2010 11:41:59 ExecuteConnectScript starts
07.09.2010 11:41:59 TOracleQuery $02B9D120 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
07.09.2010 11:41:59 TOracleQuery $02B9D120 End
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D120 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
07.09.2010 11:41:59 TOracleQuery $02B9D120 End
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D120 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
07.09.2010 11:41:59 TOracleQuery $02B9D120 End
Duration = 0
07.09.2010 11:41:59 ExecuteConnectScript ends
07.09.2010 11:41:59 TOracleQuery $02B9D120 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
07.09.2010 11:41:59 TOracleQuery $02B9D120 End (1 record processed)
Duration = 0
07.09.2010 11:41:59 TOracleSession $02BF9490 Start Session.LogOn as mmwh@VTBTEST.world
07.09.2010 11:41:59 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
07.09.2010 11:41:59 TOracleQuery Query End (1 record processed)
Duration = 0
07.09.2010 11:41:59 TOracleSession $02BF9490 End
Duration = 0,079
07.09.2010 11:41:59 SetSessionAction starts: Main session
07.09.2010 11:41:59 TOracleQuery $02B9CFC0 Start Query.Execute
SQL = select null from dual
07.09.2010 11:41:59 TOracleQuery $02B9CFC0 End (1 record processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9CFC0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
07.09.2010 11:41:59 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
07.09.2010 11:41:59 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
07.09.2010 11:41:59 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 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 = MMWH
07.09.2010 11:41:59 TOracleQuery $02B9CFC0 End
Duration = 0,016
07.09.2010 11:41:59 SetSessionAction ends
07.09.2010 11:41:59 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
07.09.2010 11:41:59 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
07.09.2010 11:41:59 SessionChanged LoadRecentObjects
07.09.2010 11:41:59 SessionChanged Notify children
07.09.2010 11:41:59 SessionChanged Logoff secondary sessions
07.09.2010 11:41:59 SessionChanged SessionMode = smMulti
07.09.2010 11:41:59 SessionChanged EnableChildFunctions
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,047
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 SessionChanged
OCIDLL forced to C:\oracle\product\11.1.0\client_1\bin\oci.dll
07.09.2010 11:41:59 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
07.09.2010 11:41:59 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,015
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,016
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,016
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (36 records processed)
Duration = 0,015
07.09.2010 11:41:59 TOracleQuery $02B9D280 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 = MMWH
07.09.2010 11:41:59 SortPreferenceSets
07.09.2010 11:41:59 - Default vietsi
07.09.2010 11:41:59 - System Default
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,406
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,016
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,016
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9CFC0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
07.09.2010 11:41:59 TOracleQuery $02B9CFC0 End (0 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9CFC0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
07.09.2010 11:41:59 TOracleQuery $02B9CFC0 End (0 records processed)
Duration = 0
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,062
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,016
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:41:59 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,015
07.09.2010 11:41:59 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,016
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,031
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,016
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,016
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,031
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,015
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,031
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,016
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,016
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,093
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 FormActivate start
07.09.2010 11:42:00 FormActivate end
07.09.2010 11:42:00 WMUpdatePopups starts
07.09.2010 11:42:00 LoadDesktop starts
07.09.2010 11:42:00 DoUpdateChildList
07.09.2010 11:42:00 LoadDesktop ends
07.09.2010 11:42:00 WMUpdatePopups ends
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,187
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:00 TOracleQuery $02B9D280 End (100 records processed)
Duration = 0,204
07.09.2010 11:42:00 TOracleQuery $02B9D280 Start Query.Next for up to 100 records
07.09.2010 11:42:04 TOracleQuery $02B9D280 End (90 records processed)
Duration = 3,828
07.09.2010 11:42:04 TOracleQuery $02B9D280 Start Query.Execute
SQL = select db_link as object_name, 'DATABASE LINK' as object_type
from sys.all_db_links o
where o.owner = :schema or o.owner = 'PUBLIC'
:SCHEMA = MMWH
07.09.2010 11:42:04 TOracleQuery $02B9D280 End (12 records processed)
Duration = 0,031
07.09.2010 11:42:04 TOracleSession $02BF9490 Start Session.LogOff
07.09.2010 11:42:04 TOracleSession $02BF9490 End
Duration = 0
07.09.2010 11:44:44 Create TSQLForm Start
07.09.2010 11:44:44 Create TSQLForm Inherited
07.09.2010 11:44:45 TSQLForm.FormCreate Start
07.09.2010 11:44:45 SQLForm
07.09.2010 11:44:45 TSQLForm.FormCreate Finished
07.09.2010 11:44:45 Create TSQLForm SetupMainFont
07.09.2010 11:44:45 Create TSQLForm Activate
07.09.2010 11:44:45 Create TSQLForm Activate done
07.09.2010 11:44:45 Create TSQLForm UpdateWindowList
07.09.2010 11:44:45 UpdateChildList [timer]
07.09.2010 11:44:45 Create TSQLForm Positioning
07.09.2010 11:44:45 Create TSQLForm Finished
07.09.2010 11:44:45 ExecuteTemplateByName: Default\SQL Window
07.09.2010 11:44:45 ExecuteTemplate: C:\Program Files\PLSQL Developer\Template\Default\SQL Window.tpl
07.09.2010 11:44:45 Path: C:\Program Files\PLSQL Developer\Template\Default\SQL Window.tpl
07.09.2010 11:44:45 NavigationBookmarks.EnableButtons(Rebuild)
07.09.2010 11:44:45 NavigationBookmarks: Backward=0, Forward=0
07.09.2010 11:44:45 DoUpdateChildList
07.09.2010 11:44:56 NavigationBookmarks.EnableButtons(Rebuild)
07.09.2010 11:44:56 NavigationBookmarks: Backward=0, Forward=0
07.09.2010 11:45:01 SQLForm Initializing...
07.09.2010 11:45:01 SetConnected starts
07.09.2010 11:45:01 SetConnected: Connect starts
07.09.2010 11:45:01 TOracleSession $02BFBE90 Start Session.LogOn as mmwh@VTBTEST.world
07.09.2010 11:45:01 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
07.09.2010 11:45:01 TOracleQuery Query End (1 record processed)
Duration = 0
07.09.2010 11:45:01 TOracleSession $02BFBE90 End
Duration = 0,079
07.09.2010 11:45:01 SetConnected: (Dis)connect ends
07.09.2010 11:45:01 SetSessionAction starts: SQL Window - New
07.09.2010 11:45:01 TOracleQuery $02B9C8E0 Start Query.Execute
SQL = select null from dual
07.09.2010 11:45:01 TOracleQuery $02B9C8E0 End (1 record processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
07.09.2010 11:45:01 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
07.09.2010 11:45:01 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery $02B9C8E0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
07.09.2010 11:45:01 TOracleQuery $02B9C8E0 End
Duration = 0
07.09.2010 11:45:01 SetSessionAction ends
07.09.2010 11:45:01 ExecuteConnectScript starts
07.09.2010 11:45:01 TOracleQuery $02B9C8E0 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
07.09.2010 11:45:01 TOracleQuery $02B9C8E0 End
Duration = 0
07.09.2010 11:45:01 TOracleQuery $02B9C8E0 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
07.09.2010 11:45:01 TOracleQuery $02B9C8E0 End
Duration = 0
07.09.2010 11:45:01 TOracleQuery $02B9C8E0 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
07.09.2010 11:45:01 TOracleQuery $02B9C8E0 End
Duration = 0
07.09.2010 11:45:01 ExecuteConnectScript ends
07.09.2010 11:45:01 TOracleQuery $02B9C8E0 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
07.09.2010 11:45:01 TOracleQuery $02B9C8E0 End (1 record processed)
Duration = 0,016
07.09.2010 11:45:01 EnableOutput starts
07.09.2010 11:45:01 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 = 100000
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
07.09.2010 11:45:01 EnableOutput done
07.09.2010 11:45:01 InitStatistics starts
07.09.2010 11:45:01 TStatistics.Init starts
07.09.2010 11:45:01 InitStatNames starts
07.09.2010 11:45:01 select name from v$statname order by statistic#
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select name from v$statname order by statistic#
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,015
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.DynamicQuery End (0 records processed)
Duration = 0
07.09.2010 11:45:01 InitStatNames ends
07.09.2010 11:45:01 StatQuery.Describe starts
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.StatQuery Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.StatQuery End
Duration = 0,047
07.09.2010 11:45:01 StatQuery.Describe ends
07.09.2010 11:45:01 TStatistics.Init ends
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 2105
07.09.2010 11:45:01 TOracleQuery PLSQLDevForm.StatQuery End (500 records processed)
Duration = 0
07.09.2010 11:45:01 InitStatistics ends
07.09.2010 11:45:01 SQL Window Height = 728
07.09.2010 11:45:01 SQL Grid Height = 649
07.09.2010 11:45:01 SQL Panel Height = 79
07.09.2010 11:45:01 NavigationBookmarks.EnableButtons(Rebuild)
07.09.2010 11:45:01 NavigationBookmarks: Backward=0, Forward=0
07.09.2010 11:45:01 SQLForm Executing...
07.09.2010 11:45:01 SQLForm Executing...
07.09.2010 11:45:01 TSQLThread SQLThread.Execute
07.09.2010 11:45:01 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
07.09.2010 11:45:01 TOracleQuery Query End
Duration = 0
07.09.2010 11:45:01 TOracleQuery $02B9CBA0 Start Query.Execute
SQL = select * from dbo.custtable@dax_dynamics where accountnum='4002'
07.09.2010 11:46:22 NavigationBookmarks.EnableButtons(Rebuild)
07.09.2010 11:46:22 NavigationBookmarks: Backward=0, Forward=0
07.09.2010 11:47:00 TOracleQuery $02B9CBA0 End
Result = ORA-00600: Interner Fehlercode, Argumente: [HO define: Long fetch], [], [], [], [], [], [], []
Duration = 119,204
07.09.2010 11:47:00 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
07.09.2010 11:47:00 TOracleQuery Query End
Duration = 0
07.09.2010 11:47:00 TOracleSession $02BFBE90 Start Session.Rollback
07.09.2010 11:47:00 TOracleSession $02BFBE90 End
Duration = 0,093
07.09.2010 11:47:00 TSQLThread SQLThread Postmessage
07.09.2010 11:47:00 TSQLThread SQLThread Suspend
07.09.2010 11:47:00 TSQLForm.ThreadFinished
07.09.2010 11:47:00 TSQLForm.ThreadFinished: SQLThread.Suspended


[/quote]

Last edited by overall7k; 09/07/10 10:57 AM.
Re: Error message by selecting data over an Oracle gateway
overall7k #38705 09/08/10 09:42 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
You seem to be running into the problem as described in Oracle Note 458441. You already now the workaround they provided: "select all columns directly instead of using a *".


Marco Kalter
Allround Automations
Re: Error message by selecting data over an Oracle gateway
Marco Kalter #38710 09/08/10 01:30 PM
Joined: Sep 2010
Posts: 6
O
Member
OP Offline
Member
O
Joined: Sep 2010
Posts: 6
Ok, thank you for the information

But it is a little bit exhausting writing more than 300 columns in every select statement

The strange thing is, that the error (when selecting with *) comes only in the PL/SQL Developer and not on the sqlplus command line

Regarding to the Oracle Metalink, the bug should be closed in the 11g version
I asked the Oracle support and they confirmed this

Re: Error message by selecting data over an Oracle gateway
overall7k #38715 09/09/10 09:57 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
What happens if you create a view for the table@gateway?


Marco Kalter
Allround Automations
Re: Error message by selecting data over an Oracle gateway
Marco Kalter #38733 09/13/10 11:54 AM
Joined: Sep 2010
Posts: 6
O
Member
OP Offline
Member
O
Joined: Sep 2010
Posts: 6
the same error occurs

Re: Error message by selecting data over an Oracle gateway
overall7k #38765 09/16/10 11:39 AM
Joined: Sep 2010
Posts: 6
O
Member
OP Offline
Member
O
Joined: Sep 2010
Posts: 6
any solution for this problem ?

kind regards

Re: Error message by selecting data over an Oracle gateway
overall7k #38767 09/17/10 07:00 AM
Joined: Mar 2007
Posts: 210
Rostock, Germany
Member
Offline
Member
Joined: Mar 2007
Posts: 210
Rostock, Germany
Hi,

this is an Oracle-Bug. You have to look for Patches for your Database, not for PLD.


There is no shortcut for experience(d).

PL/SQL Developer Version 10+11+12, Query Reporter Version 3.2.0.300
Oracle 11g,12c
Windows Server 2003/2008
Windows 10 Professionel 64 bit



Re: Error message by selecting data over an Oracle gateway
Theod #38776 09/19/10 02:54 PM
Joined: Sep 2010
Posts: 6
O
Member
OP Offline
Member
O
Joined: Sep 2010
Posts: 6
Hi

Regarding to metalink the bug appears only for 9 and 10g, but I'm using 11g
The other thing is, that I have tried the SQL statements with Oracle SQL Developer and there it works fine

kind regards



Moderated by  support 

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

PHP: 7.1.33 Page Time: 0.027s Queries: 15 (0.007s) Memory: 2.6176 MB (Peak: 3.0392 MB) Data Comp: Off Server Time: 2024-03-28 13:15:37 UTC
Valid HTML 5 and Valid CSS