Fectch out of sequence
Posted: 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.
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.