oracle函数、存储过程、序列

一. 函数

　　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