clob 转换为blob
来源:互联网 发布:蒙古帝国 知乎 编辑:程序博客网 时间:2024/05/14 09:55
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;
END C2B;
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;
END C2B;
0 0
- clob 转换为blob
- java 读取clob,blob转换为字符串
- BLOB转换为CLOB的函数(oracle中执行)
- java 读取Oracle的clob,blob转换为字符串
- Blob,Clob类型转换String
- Oracle中Blob转换成Clob
- CLOB转换为STRING
- Oracle clob无法修改为blob
- clob 、blob
- clob&blob
- jdbc操作Blob和Clob字段与字符串的转换
- 【Oracle】 Blob转Clob的字符UTF16转换UTF8问题
- 数据库的CLOB/BLOB字段存为本地txt java
- CLOB、BLOB , CLOB与BLOB的区别
- CLOB、BLOB , CLOB与BLOB的区别
- CLOB、BLOB , CLOB与BLOB的区别
- CLOB、BLOB , CLOB与BLOB的区别
- CLOB、BLOB , CLOB与BLOB的区别
- angularjs学习之路---使用$q进行“同步”编程
- VMware 鼠标键盘问题
- python打包发布方法
- Android 属性动画(Property Animation) 完全解析 (上)
- 安卓高德地图开发(2)——定位
- clob 转换为blob
- 背包九讲
- Android 属性动画(Property Animation) 完全解析 (下)
- xcode 中 UILable 使用方法简介
- 使用Apache的ab工具进行压力测试
- Android里的相对坐标
- android中实现View的振动
- PHP中常用代码块集锦
- 混合所有制股份公司的产权关系及其作用