unzip files in BLOB column

[rugbyhob007]

Hi All,

I store a zip file in a single oracle BLOB(using a OA framework page.) column.They are composed of a PDF,.doc etc.,

I want to unzip the files in the BLOB column and store each of the individual files in a separate BLOB column in other table.

How to achieve this?

Any pointers or suggestions will be highly appreciated