This discussion is archived
4 Replies Latest reply: Feb 26, 2010 4:02 AM by 722624 RSS

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

722624 Newbie
Currently Being Moderated
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,
tableName in VARCHAR2,
columnName in VARCHAR2,
whereClause in VARCHAR2,
asynchronous in BOOLEAN default FALSE,
callbackTrigger in VARCHAR2 default NULL
) return BOOLEAN;

Can you say?
FUNCTION Webutil_File_Transfer.Client_To_DB
(
clientFile in VARCHAR2,
tableName in VARCHAR2,
utl_compress.lz_compress(columnName),
whereClause in VARCHAR2,
asynchronous in BOOLEAN default FALSE,
callbackTrigger in VARCHAR2 default NULL
) return BOOLEAN

Edited by: Channa on Feb 19, 2010 1:45 AM

Edited by: Channa on Feb 19, 2010 1:46 AM

Edited by: Channa on Feb 19, 2010 1:46 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points