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

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.