tOracleOutput can't write string to oracle blob data type

One Star

tOracleOutput can't write string to oracle blob data type

IN TOS 2.1.0 JAVA on LINUX
tOracleOutput can't write string to oracle blob data type :
xception in component tOracleOuput_1
java.sql.SQLException: ORA-01465: invalid hex number
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2960)
at datawarehouse.copy_of_dim_create_locations.Copy_of_Dim_Create_Locations.tMysqlInput_2Process(Copy_of_Dim_Create_Locations.java:666)
at datawarehouse.copy_of_dim_create_locations.Copy_of_Dim_Create_Locations.main(Copy_of_Dim_Create_Locations.java:826)
I've narrowed the error to this so I'd like to know if we just can't write strings to blob data type in oracle (because we do in MySQL) or is it really a bug and it should be possible.
Thx,
Employee

Re: tOracleOutput can't write string to oracle blob data type

Hello,
I'm not very sure because I have to reinstall my Oracle, but I think you can change your data type to Object or byte[] in Talend's schema.
Please let me know if it helps.
Regards,
Michaël
One Star

Re: tOracleOutput can't write string to oracle blob data type

Hello,
I have the same problem : tOracleinput --> tmap --> tOracleoutput
I have to load a varchar2 (String in TOS) into a CLOB (Oject in TOS) but I have the same error : "ORA-01465: invalid hex number"
a field type "Object" creates a BLOB column in the oracle table, is It possible to create a CLOB instead?
PS : my TOS version is :4.0.0RC2
Thx for your help