import java.lang.*;
import oracle.sql.*;
import java.io.*;
import java.util.zip.*;

public class LobCompressor2 {

public static void compress(BLOB slob, String slobName, BLOB blob) throws Exception {
InputStream in=slob.getBinaryStream();
//ZipOutputStream z=new ZipOutputStream(blob.getBinaryOutputStream());
ZipOutputStream z=new ZipOutputStream(blob.setBinaryStream(0));

byte[] buffer=new byte[slob.getBufferSize()];
z.putNextEntry(new ZipEntry((new File(slobName)).getName()));
int cnt;
while ((cnt=in.read(buffer))!=-1) {
z.write(buffer,0,cnt);
}
z.closeEntry();
in.close();
z.close();
}

public static void compress2(BLOB slob1, String slob1Name, BLOB slob2, String slob2Name, BLOB blob) throws Exception {
InputStream in1=slob1.getBinaryStream();
InputStream in2=slob2.getBinaryStream();
//ZipOutputStream z=new ZipOutputStream(blob.getBinaryOutputStream());
ZipOutputStream z=new ZipOutputStream(blob.setBinaryStream(0));

  // add first
byte[] buffer1=new byte[slob1.getBufferSize()];
z.putNextEntry(new ZipEntry((new File(slob1Name)).getName()));
int cnt1;
while ((cnt1=in1.read(buffer1))!=-1) {
z.write(buffer1,0,cnt1);
}
z.closeEntry();
in1.close();

  // add second
byte[] buffer2=new byte[slob2.getBufferSize()];
z.putNextEntry(new ZipEntry((new File(slob2Name)).getName()));
int cnt2;
while ((cnt2=in2.read(buffer2))!=-1) {
z.write(buffer2,0,cnt2);
}
z.closeEntry();
in2.close();

z.close();
}

// decompress file from gzip archive
public static void decompress(BLOB slob, BLOB outblob ) throws Exception {

OutputStream    out  = outblob.getBinaryOutputStream();
GZIPInputStream z    = new GZIPInputStream(slob.getBinaryStream());

byte[] buffer=new byte[1024];

int cnt;
while ((cnt=z.read(buffer))!=-1) {
out.write(buffer,0,cnt);
}
z.close();
out.close();
}

// Decompresses file with .xml extention from zip archive
public static void decompress2(BLOB sblob, BLOB outblob) throws Exception {

  OutputStream out = outblob.getBinaryOutputStream();

  ZipInputStream zis = new ZipInputStream(sblob.getBinaryStream());
  
  byte[] buffer = new byte[1024];
  
  ZipEntry zipEntry = zis.getNextEntry();
  
       while (zipEntry != null) {
           
            if (zipEntry.getName().matches(".*.xml")) {
              int len;
              while ((len = zis.read(buffer)) > 0) {
                  out.write(buffer, 0, len);
              }
              out.close();
            }
            zipEntry = zis.getNextEntry();
        }
        zis.closeEntry();
        zis.close();
}

}
;

create or replace procedure blob_decompress2(p_slob blob, p_blob blob)
as language java
name 'LobCompressor2.decompress2(oracle.sql.BLOB, oracle.sql.BLOB)';

declare 
  p_s blob;
  p_b blob;
  
 BEGIN
      dbms_lob.createtemporary(p_b,true);
      select bl into p_s from t1 where id=276046 for update; -- здесь надо так
      blob_decompress_zip(p_s, p_b);
      update t1 set bl_=p_b where id=276046; 
      commit;
     dbms_lob.freetemporary(p_b);
 END;