Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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,
Labels (4)
2 Replies
Anonymous
Not applicable
Author

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
_AnonymousUser
Specialist III
Specialist III

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