Error Ora-01002 Fetch Out Of Sequence Using Microsoft ODBC Driver To Query Oracle View That Uses TG4DB2400 (Doc ID 432884.1)

Last updated on DECEMBER 21, 2010

Applies to:

Oracle Database Gateway for DB2/400 - Version: 10.1 to 10.2

Symptoms

Checked for relevance on 22-Dec-2010.

 

When users run a query from Access to an Oracle view using the Microsoft ODBC driver for Oracle   they get error -

Select *

 

From Openquery( pstage, ‘

 

Select *

 

From pstage.con_equipment_movement_deatil’)

 

ORA-01002 fetch out of sequence 

The Oracle view references data on an AS400 using TG4DB2400. 





Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms