DSXchange

The job is aborting when i am extracting the records from the Oracle database The error description is
"ODBC read source,0:ODBC function "SQLFetch" reported: SQLState=HY000: Native error code=1,002: Msg=[IBM(DataDirect OEM)][ODBC "Oracle wire protocol driver][Oracle]ORA-01002: fetch out of sequence

I am using the following options
Record Count:2000
ArrySize:2000
Isolation Level: Read Uncommited

Can any one please help

This is happening in your Oracle database, not in DataStage. Pull out the query you are using and talk with your Oracle DBA about why it might be generating this error.

What does your SQL look like? Is the stage generating it or did you supply it?