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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MDouglas1687874333
Contributor III
Contributor III
a week ago

Best way to handle an Oracle BLOB

I have a setup with an oracle component that makes a call to a database and returns a BLOB datatype. The BLOB only contains textual information (I know a CLOB would work better but this is the way the database is structured) and I want to extract this as a byte array and pass this to a tFileOutputRaw. 

Current skeleton/prototype: 

MDouglas1687874333_1-1758287014000.png

 

Talend seems to want to treat it as an object, if the notification from the component and the DB TYPE being orange in the schema implies this? 

MDouglas1687874333_0-1758286909742.png

 

 

This goes away when I set it to an object but it being an oracle.sql.BLOB object type, I am unsure how this should be used. I would want to get the textual value from the blob but I'm not sure how to work with this object. Any advice on this would be appreciated.

NOTE: Using a byte array works perfectly fine for this, but I am curious what, if any, benefit would be gained from using an object instead? 

Labels (7)
Labels
103 Views
0 Likes
0 Replies