Extract Blob from Oracle

[Anonymous]

Hello,
i work in an oracle database and i want to extract pictures of client. This pics was encoded in Blob field.
I try to export in tfiledelimited, but it doesn't work because i have 275 clients.
I would like to know how i can create 275 jpg files and if it's possible rename pic with the id_cli (primary key)

regards
Dams

[Anonymous]

Ok, now works. It was my fault with the schema.
sorry about that.

[Anonymous]

Great to hear 😉

[Anonymous]

Hello,
I just downloaded this tLobdownload component and tried to use it.
I have a problem. I am wondering what data type I should put for the blob column. See the attached image. Thanks!

[Anonymous]

No please use as type Object. If you let the studio decide the type in this case it does not work.

[Anonymous]

Thanks! It works fine now.

[Anonymous]

Great! Have a lot of fun... (This was for a couple of years ago the standard greeting of SuSE Linux 😉 

[Anonymous]

sorry, the component doesn't work for me...
context.pathWORKSPACE1 is the directory where I want to save the files
tjavarow_1  shows information only
no error, no files.... What happen? I'm running 5.4.1 on ubuntu linux.
thanks for your help.

logarda,
After I added a javarow in bewteen dbinput and tLOBDownload components, I got nothing saved in my output. No error. May I know how you solved the problem?
Thanks!

[Anonymous]

The tJavaRow does not connect the flows automatically. You have to synchronise the schema and click on Generate Code to get the Java code to transfer the values. After this you can add you own code or tweak the existing one.  

[Anonymous]

Exactly! Thanks, jlolling!

[Anonymous]

Hi jlolling,
If I want to process the output file from stream instead of saving it to a file, do you know if there is a way?
The workflow is like this: DBInput - tJavaRow - tFileInputExcel.
It is work fine if save the blob into a file and let tFileInputExcel read from a file. I am wondering if we can let tFileInputExcel directly read from stream.
Thanks!