Page 1 of 1

Error message: ORA-24374: define not done before fetch or ex

Posted: Mon Apr 21, 2014 10:15 pm
by deesh
Hi,

I am phasing below error, i searched in dsxchange but i didn't found the correct answer.

DS Version : 9.1.2
Stage: oracle connector

Read_Base_Table_Historical,0: The OCI function OCIStmtFetch2 returned status -1. Error code: 24,374, Error message: ORA-24374: define not done before fetch or execute and fetch. (CC_OraStatement::fetch, file CC_OraStatement.cpp, line 1,599)

Posted: Mon Apr 21, 2014 10:39 pm
by chulett
So... we're supposed to guess what exactly it is you are doing in the stage?

Posted: Mon Apr 21, 2014 10:48 pm
by deesh
yes,

we are feching records through oracle connector and done the manipulation through storeprocdure and store it in oracle table.

our project default NLS is UTF-18.

even i am going to check NLS change to ASCII let's check.

Posted: Tue Apr 22, 2014 3:54 am
by prasson_ibm
Can you please explain simple what you are doing in your job design.

Posted: Tue Apr 22, 2014 6:46 am
by chulett
Or at the very least, as requested, details of how you are 'fetching records'... how is the stage configured?