And there is no data set options in your proc append?
Two ideas:
you seem to read one more record than gets inserted. Is there a data problem in that record? What constraints do you have on the oracle table?
You might hit some kind of limit in Oracle, check with your DBA to see if he/she can find anything in the Oracle logs that could help.
... View more