ORACLE clob转换成Blob类型

最新推荐文章于 2022-06-03 10:14:42 发布

dfgppwzkb17977379

最新推荐文章于 2022-06-03 10:14:42 发布

阅读量221

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/zeromyth/archive/2009/11/06/1597505.html

版权

ORACLE 10G R2上

测试通过。

CREATE OR REPLACE FUNCTION C2B (b IN CLOB default empty_clob())
    RETURN BLOB
-- typecasts BLOB to CLOB (binary conversion)
IS
   res            BLOB;
   b_len           number   : = dbms_lob.getlength(b) ;
   dest_offset1    NUMBER   : = 1 ;
   src_offset1     NUMBER   : = 1 ;
   amount_c        INTEGER : = DBMS_LOB.lobmaxsize;
   blob_csid       NUMBER   : = DBMS_LOB.default_csid;
   lang_ctx        INTEGER : = DBMS_LOB.default_lang_ctx;
   warning         INTEGER ;
BEGIN

    if   b_len   > 0    then
   DBMS_LOB.createtemporary (res, TRUE);
   DBMS_LOB. OPEN (res, DBMS_LOB.lob_readwrite);
   DBMS_LOB.convertToBlob (res,
                           b,
                           amount_c,
                           dest_offset1,
                           src_offset1,
                           blob_csid,
                           lang_ctx,
                           warning
                          );
else
    select    empty_blob()   into   res   from   dual ;
   end if ;
    RETURN res;                                              -- res is OPEN here
END C2B;

转载于:https://www.cnblogs.com/zeromyth/archive/2009/11/06/1597505.html