public static CLOB decompress(BLOB blob) throws Exception {
        CLOB slob = CLOB.createTemporary(db, false, CLOB.DURATION_SESSION);
        GZIPInputStream zin = new GZIPInputStream(blob.getBinaryStream());
        OutputStream out = slob.getAsciiOutputStream();

        try{
            byte[] buffer=new byte[blob.getBufferSize()];

            int cnt;
            while ((cnt=zin.read(buffer)) > 0) {
            out.write(buffer,0,cnt);
            }
        } finally {
            zin.close();
            out.flush();
            out.close();
        }
        return slob;
    }
    public static BLOB compress(CLOB slob) throws Exception {
        BLOB blob = BLOB.createTemporary(db, false, BLOB.DURATION_CALL);
        InputStream in = slob.getAsciiStream();
        GZIPOutputStream zout = new GZIPOutputStream(blob.setBinaryStream(0L)) {
            {
                def.setLevel(Deflater.BEST_COMPRESSION);
            }
        };

        try {
            byte[] buffer = new byte[slob.getBufferSize()];

            int cnt;
            while ((cnt = in.read(buffer)) > 0) {
                zout.write(buffer, 0, cnt);
            }
        } finally {
            in.close();
            zout.finish();
            zout.flush();
            zout.close();
        }
        
        return  blob;
    }