Problems inserting into an Oracle 9.2 database
Posted: Wed Oct 06, 2004 8:59 am
I'm having a problem inserting into a Oracle 9.2 database from DataStage where the NLS_CHARSET of the database server is AL32UTF8. See below for the error message:
JCTest1..Transformer_1.DSLink4: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO SIEBEL.JC_TEST1(FIELD1, FIELD2, FIELD3) VALUES (?,?,?)
SQLSTATE=HY000, DBMS.CODE=1461
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver][Oracle]ORA-01461: can bind a LONG value only for insert into a LONG column
FIELD1 = "XYZ"
FIELD2 = "This is another test"
FIELD3 = "789"
Note that there are no LONG columns in the table. The same job works fine when inserting into an ORacle 9.2 database with NLS_CHARSET = UTF8.
Has anyone else experienced this problem? I'm assuming at the moment that it is an Oracle problem rather than DataStage. Probably the Oracle client on the DataStage server which is version 8.1.7, but might also be the NLS_CHARSET setting of the client.
Regards,
Jeremy.
JCTest1..Transformer_1.DSLink4: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO SIEBEL.JC_TEST1(FIELD1, FIELD2, FIELD3) VALUES (?,?,?)
SQLSTATE=HY000, DBMS.CODE=1461
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver][Oracle]ORA-01461: can bind a LONG value only for insert into a LONG column
FIELD1 = "XYZ"
FIELD2 = "This is another test"
FIELD3 = "789"
Note that there are no LONG columns in the table. The same job works fine when inserting into an ORacle 9.2 database with NLS_CHARSET = UTF8.
Has anyone else experienced this problem? I'm assuming at the moment that it is an Oracle problem rather than DataStage. Probably the Oracle client on the DataStage server which is version 8.1.7, but might also be the NLS_CHARSET setting of the client.
Regards,
Jeremy.