get blob

get_blob.groovy

//try
def blobFile = new File(fileName)
def outStream = new FileOutputStream(blobFile)

def blob = (oracle.sql.BLOB) result[0]
def inStream = blob.getBinaryStream()

int length = -1
int size = blob.getBufferSize()
byte[] buffer = new byte[size]

while ( ( length = inStream.read(buffer) ) != -1 ) {
  outStream.write(buffer, 0, length)
  outStream.flush()
}
inStream.close()
outStream.close()

//catch