Need code to save Blob into a file

[rajkumarpandit]

Searched a lot but couldn't find a correct example of downloading a pdf file from oracle db, stored in blob column, and saving it locally ( unix machine, where I run perl code)

thanks in advance for providing code or giving me a link. regards, raj

[1nickt]

Hi raj,

What have you tried so far? How does it fail for you?

See How do I post a question effectively?.

You should be able to fetch an item from your database using the DBI and DBD::Oracle.

You may want to pay particular attention to the LongReadLen attribute when using them.

Hope this helps!

[LanX]

Well it depends ...¹

Probably you just need to read binmode

¹) for instance if it was already stored properly.

[graff]

Did you try using the Super Search link here at the monastery, and looking for the word "blob"? I got this node on the second page of results. I expect there are probably more (in case that one doesn't have enough info for you).