Invalid precision value. Error in parameter 6
Moderators: chulett, rschirm, roy
Invalid precision value. Error in parameter 6
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.....!
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.....!
Abhinav
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes, that's what triggered my question. We had no information about the Oracle version.chulett wrote:An Oracle VARCHAR2 can support up to 4000, unless the version is very old.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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
Abhinav
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: