My Oracle Support Banner

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


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. 


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

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