How to compress data and store them in a table?

[zephan]

Hi,

I have a distribution list, and each destinator should receive an attachement. The attachement is a text generated on the fly from the database and then stored in a LOB.

But due to mailbox limitation, I have to compress the text before to send it, with standard compression like zip or rar that users are able to open from their winbox.

Is there any standard Oracle Package to compress long text or LOB and store it again (in the same or in another LOB).

Thanks

 

[Dagon]

SYS.UTL_COMPRESS.

Retired (not by choice) Oracle contractor.