一. 函数 1. c2b函数:clob转blob create or replace function c2b (b in clob default empty_clob())return blobis res blob; bLen number := dbms_lob.g ...
一. 函数
1. c2b函数:clob转blob
create or replace function c2b (b in clob default empty_clob())return blobis res blob; bLen number := dbms_lob.getlength(b); destOffset1 number := 1; srcOffset1 number := 1; amountC integer := dbms_lob.lobmaxsize; blobCsid number := dbms_lob.default_csid; langCtx integer := dbms_lob.default_lang_ctx; warning integer;begin if bLen > 0 then dbms_lob.createtemporary(res, true); dbms_lob.open(res, dbms_lob.lob_readwrite); dbms_lob.convertToBlob(res, b, amountC, destOffset1, srcOffset1, blobCsid, langCtx, warning ); else select empty_blob() into res from dual; end if; return res;end c2b;
原标题:oracle函数、存储过程、序列
关键词:oracle
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。