-- Compression package for Oracle XE
-- please ignore  install LobCompressor_java.sql: see Install Guide 6/a
CREATE OR REPLACE PACKAGE Plpdf_Comp IS
---------------------------------------------------------------------------------------------------
c_support constant varchar2(3 char) := 'NO';
---------------------------------------------------------------------------------------------------
FUNCTION blob_compress(p_blob BLOB) RETURN BLOB;
---------------------------------------------------------------------------------------------------
FUNCTION blob_decompress(p_blob BLOB) RETURN BLOB;
---------------------------------------------------------------------------------------------------
END;
/

CREATE OR REPLACE PACKAGE BODY Plpdf_Comp IS
---------------------------------------------------------------------------------------------------
FUNCTION blob_compress(p_blob BLOB) RETURN BLOB IS
BEGIN
  RETURN p_blob;
END;
---------------------------------------------------------------------------------------------------
FUNCTION blob_decompress(p_blob BLOB) RETURN BLOB IS
BEGIN
  RETURN p_blob;
END;
---------------------------------------------------------------------------------------------------
END;
/