My Oracle Support Banner

Endless Loop When Querying Table (in SQL Worksheet) via Database Link to DB2 Database (Doc ID 1480742.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle SQL Developer - Version 3.1 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

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 table1@db2_test; --  (without "order by" clause)
     Result: The select is looping endless

2. Select * from table1@db2_test order by code;  -- (with "order by" clause)
    Result: The output gives the correct number of rows .

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.