Reading and FTPing BLOB using datastage

dinthat · Post by **dinthat** » Tue Jun 03, 2008 9:04 am

Hi All,

My requirement is very simple. I 've one oracle table as source, which is having one column with data type as BLOB and this column is storing images. Now I need to read this column using Datastage and FTP this images to my UNIX server as image files.

Can anybody help me to solve this?

ArndW · Post by **ArndW** » Tue Jun 03, 2008 9:35 am

BLOBs and CLOBs aren't supported. You can actually write to a LOB, but cannot read from it. If you know your maximum length you can write a workaround SQL query that uses CAST to move 4000 character substrings from the LOB into VarChar2(4000) columns. We just did this for LOBs that we know won't exceed 200Kb so only had to write 50 columns for temporary use.