Error while fetching records through OCI stage

sumesh.abraham · Post by **sumesh.abraham** » Thu Jan 29, 2009 8:53 am

All,

I'm reading records from Oracle table using OCI stage and write to a sequential file. The query performs UNION all operation on two tables which have history records and these tables have huge number of records. When I run the job, the job gets aborted with error

Ora - Fetch out of sequence

I'm performing min and max date functions on 2 date columns in all union statements in the query.

What is the cause? Any help would be highly appreciated. If required I can post the query.

chulett · Post by **chulett** » Thu Jan 29, 2009 8:55 am

First suggestion - search the forums for "Fetch out of sequence" and see if any help solve your problem.

sumesh.abraham · Post by **sumesh.abraham** » Thu Jan 29, 2009 9:54 am

Craig,

My search for 'Fetch out of sequence' didn't return any results.

What could be the cause? Appreciate your help.

Thanks.

chulett · Post by **chulett** » Thu Jan 29, 2009 10:06 am

Make sure you are doing an "Exact" match, I got 8 matches when I tried it.