topic tOracleOutput can't write string to oracle blob data type in Talend Studio

tOracleOutput can't write string to oracle blob data type

Anonymous — Sat, 16 Nov 2024 14:34:37 GMT

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,

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

Anonymous — Wed, 18 Jul 2007 22:34:41 GMT

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

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

_AnonymousUser — Fri, 30 Apr 2010 12:03:01 GMT

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