String to Blob with TJdbcOuput and Oracle driver

[_AnonymousUser]

Hello,
I have a long input String and need to save it into Oracle database via JDBC.
When i look convert TalendType to get blob in database i see : Id_Object => Blob
Someone could say me please how construct this object from a String ?
Regards

[Anonymous]

Hi,
Need to convert your input string to byte[]
Then insert this byte to BLOB column. Pl refer...
https://community.talend.com/t5/Design-and-Development/Inserting-BLOB-or-CLOB-data-into-a-database/t...
earlier I have inserted a CSV file into MySQL BLOB. I can read the contents of file in BLOB column.
Vaibhav

[_AnonymousUser]

Thanks, with Mysql you can do as this but TOracleOut need data type Object not byte[]

[Anonymous]

In the referred routine java code, convert to Object in place of byte[].
Is there any other problem?
Vaibhav

[_AnonymousUser]

Yes , but what kind of of Object? How construct this object?

[_AnonymousUser]

Finally it works with myString.getBytes()
Thanks and regards