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 FEBRUARY 05, 2019

Applies to:

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

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

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.