Create zip file from the BLOB column in ORACLE DB

[nnsatpute]

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

[ndc85430]

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.

[ibreeden]

I think the document Using CLOB and BLOB Data will be helpful for you.