Oracle Application Express (MOSC)

MOSC Banner

How to download a file stored as a compressed BLOB

edited Jul 29, 2013 4:44AM in Oracle Application Express (MOSC) 3 commentsAnswered
I have a BLOB column in my table which contains compressed files (using UTL_COMPRESS.LZ_COMPRESS).  I want to be able to add a download link to a report listing all the files, which gives access to the uncompressed file when clicked so that it can be saved locally.

I have followed various documentation / tutorials for declaratively downloading BLOBs, but it does not appear to support anything other than downloading the raw (compressed) BLOB itself.  I essentially want to inject a call to UTL_COMPRESS.LZ_UNCOMPRESS() somewhere, but I don't seem to be able to find any way to do it.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center