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 MAY 11, 2022

Applies to:

Oracle Database Gateway for DB2/400 - Version 10.1 to 10.2
Information in this document applies to any platform.




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.