4 Replies Latest reply: Feb 26, 2010 6:02 AM by user49914949919675123 RSS

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

    user49914949919675123
      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