Hi All,

I know this is an old post, but I have recently hit this problem too.

This seems to work to overcome the 99 records being lost.

The trick is to cater for the 99 records that will be lost by adding extra ones at the beginning of the table to be sent

SELECT *

FROM OPENQUERY(oracle_linked_server,

'select * from

( select a.n, b.* from

( SELECT 1 n FROM dual CONNECT BY LEVEL < 110 ) a

cross join

( select * from {oracle_table} where rownum = 1 ) b

) c

union all

select 2, d.* from {oracle_table} d

')

AS oracle_table_with_all_records

WHERE (N = 2)