How to compress/decompress BLOB column data when using WebUtil?
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