DSXchange

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.

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

Craig,

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

What could be the cause? Appreciate your help.

Thanks.

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