Invalid precision value. Error in parameter 6

[vitumati]

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.....!

[ray.wurlod]

Does your Oracle allow VARCHAR2 to be that large?

You may need to specify LONG VARCHAR2

[chulett]

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

[qt_ky]

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?

[ray.wurlod]

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.

[ray.wurlod]

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

[vitumati]

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

[ray.wurlod]

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

[vitumati]

RCP is Disable.We not enabling the RCP