1、使用oracle压缩blob对象
l_blob := utl_compress.lz_compress(l_blob);
2、将blob转换成clob
FUNCTION
blob_to_clob(blob_in
IN
BLOB
)
RETURN
CLOB
AS
v_clob
CLOB
;