Python Forum

Full Version: Create zip file from the BLOB column in ORACLE DB
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello,

I have BLOB Data in one of the oracle table column.
I want to create zip file which should contain all files (xml) in blob, this zip needs to be stored on Unix server.

Thanks
There's a module in the standard library for working with ZIP files, called, unsurprisingly zipfile. For talking to Oracle, there's cx_Oracle which looks to be maintained by Oracle themselves.
I think the document Using CLOB and BLOB Data will be helpful for you.