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.
Fectch out of sequence
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 153
- Joined: Thu May 11, 2006 1:52 am
- Location: Bangalore