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
ORA 01002 with ODBC Connector stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.