Oracle Forms (MOSC)

MOSC Banner

How to compress/decompress BLOB column data when using WebUtil?

edited Mar 30, 2010 12:04AM in Oracle Forms (MOSC) 1 commentAnswered
I am using webutil_file_transfer.client_to_db and webutil_file_transfer.db_to_client procedures to load a MS Word document to a BLOB column in a DB table and then display it in the client machine.

Now I want to add compression to this since Word docs take lots of space. There is UTL_COMPRESS.

Problem is how to plug it in to these 2 WebUtil procedures.

I don't think I can put it inside the 2 procedures. For example to load we have to use this Client_To_DB function:

FUNCTION Webutil_File_Transfer.Client_To_DB
(
clientFile in VARCHAR2,

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