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,
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
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