Fectch out of sequence

sumesh.abraham · Post by **sumesh.abraham** » Sun Mar 01, 2009 3:27 am

Hi

I have set Array Size as 1000 in the Oracle OCI stage. When run, job aborted with error ORA-01002: fetch out of sequence. When I selected the 'Disable Array Fetch' checkbox , my job finished successfully. Some times job finishes successfully even when the Disable Array Fetch is not selected. What can I do to make sure that my jobs will not abort in production. I have 30-40 jobs which uses Oracle OCI stage as source.

Appreciate your help.

chulett · Post by **chulett** » Sun Mar 01, 2009 8:40 am

Uncheck 'Array Fetch' and set your Array Size to 1 - does the job abort? What kind of columns are you selecting, any CLOB or unbound NUMBER fields? Search here for the error as well, it's been discussed a time or two.