DSXchange

Hi All,

Can you please help the bellow issue.


Job Description: (Oracle Db) reading with(ODBC Conn) both source and target and we creating generic this should word for DB like Oracle DB and DB2 etc.so that we using ODBC Conn.

Job: ODBCConn------->Transformer--------->ODBC Conn (strt move)

Error:TrgODBCCon,1: ODBC function "SQLExecute" reported: SQLSTATE = HY104: Native Error Code = 0: Msg = [IBM (DataDirect OEM)][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 6. (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 673)

I have 1 field for both source and target column data type is varchar2(1000) in oracle.


Thanks.....!

Does your Oracle allow VARCHAR2 to be that large?

You may need to specify LONG VARCHAR2

An Oracle VARCHAR2 can support up to 4000, unless the version is very old.

Are you doing anything like "select * from source_table" with RCP turned on?

What versions of DataDirect ODBC drivers and Oracle database are you using?

chulett wrote:An Oracle VARCHAR2 can support up to 4000, unless the version is very old.

Yes, that's what triggered my question. We had no information about the Oracle version.

If you have only one field, why is the error message referring to parameter 6 ?

I'm using Data stage 8.5.Oracle 10

My SRC is Oracle here I've 60 fields but only 1 field having Varchar2(1000) in SRC.due to this I'm getting above error If I remove this field job working fine.

SRC_Field Varchar2(1000) I'm loading into Trg_Field Varchar2(4000)
To read this job I tried Varchar ,LongVarchar, LongNVarchar in datastage
Here I using ODBC Conn using to connect both SRC and TRG.This job is reusable job for diff databases.so I'm using ODBC Conn stage

Disable runtime column propagation (RCP) on the output link of this stage.

RCP is Disable.We not enabling the RCP