ORACLEclob转æ¢æBlobç±»å
ãã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;
温馨提示:答案为网友推荐,仅供参考