DSXchange

Hi,

I developed a job which had a source table and a view to fetch data from that source and to load that into a target table. View fetches about 250,000. But when it is loaded into target table it has some 1000(251,000) more records than view.

I'm facing this warning . ''OCI has fetched truncated data''.
Fatal error as ''ORA-01002: fetch out of sequence ''.

Also the table got locked initially followed by job lock. So i created a copy job and released the table lock and ran that and faced these errors finally.

Any idea why i faced this error?

There might be two seperate issues you are facing.

''OCI has fetched truncated data''

There might be some column in the source which is having column length greater than the one in the target.

''ORA-01002: fetch out of sequence ''

I would recommend you to search the forum there had been few different scenarios for this issue.

Thanks. Will work on that.....