ORA 01002 with ODBC Connector stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dineshrk
Participant
Posts: 46
Joined: Thu Jun 26, 2008 9:14 pm

ORA 01002 with ODBC Connector stage

Post by dineshrk »

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 :(
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

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.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”