Clob to Blob

CREATE OR REPLACE FUNCTION C2B (b IN CLOB default empty_clob()) RETURN BLOB

AS

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;

END C2B;

   2.调用blob_to_clob 来完成转换

 update gs_gift p set p.description1=blob_to_clob(p.description);

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26764973/viewspace-1173630/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26764973/viewspace-1173630/