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

deesh · Post by **deesh** » Mon Apr 21, 2014 10:15 pm

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)

chulett · Post by **chulett** » Mon Apr 21, 2014 10:39 pm

So... we're supposed to guess what exactly it is you are doing in the stage?

deesh · Post by **deesh** » Mon Apr 21, 2014 10:48 pm

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.

prasson_ibm · Post by **prasson_ibm** » Tue Apr 22, 2014 3:54 am

Can you please explain simple what you are doing in your job design.

chulett · Post by **chulett** » Tue Apr 22, 2014 6:46 am

Or at the very least, as requested, details of how you are 'fetching records'... how is the stage configured?