Endless loop when querying table (in SQL Worksheet) via database link to DB2 database
(Doc ID 1480742.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle SQL Developer - Version 3.1 and later
Information in this document applies to any platform.
When querying a table via database link to DB2 database, the select is looping endless .
However, if you specify an "order by"-clause, then the query gives the correct output.
1. Select * from txdaten.fdbtab@db2_test; -- (without "order by" clause)
Result: The select is looping endless
2. Select * from txdaten.fdbtab@db2_test order by tbcode; -- (with "order by" clause)
Result: The output gives the correct number of rows .
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!