急!存储过程中,如何将表A中long类型的数据插入到表B中blob字段中

[cyp503]

如题

[cyp503]

up

[sql5186]

inser into aaa select to_lob(字段名) from bbb

[zxhcloth]

"cyp503 (谁怕？一蓑烟雨任平生) "您好!
如下是我写的一个函数,专程解决你这个问题的,希望对你有帮助!

CREATE OR REPLACE FUNCTION CONVERTTOBLOB(SRC IN LONG) RETURN BLOB IS
D_OFFSET INTEGER := 1;
S_OFFSET INTEGER := 1;
B_CSID NUMBER := 0;
LANG_C INTEGER := 0;
WARN INTEGER := 0;
LEN INTEGER := 0;
B BLOB;
BEGIN
DBMS_LOB.CREATETEMPORARY(LOB_LOC => B, CACHE => TRUE);
LEN := DBMS_LOB.GETLENGTH(TO_CLOB(SRC));
DBMS_LOB.CONVERTTOBLOB(DEST_LOB => B,
SRC_CLOB => TO_CLOB(SRC),
AMOUNT => LEN,
DEST_OFFSET => D_OFFSET,
SRC_OFFSET => S_OFFSET,
BLOB_CSID => B_CSID,
LANG_CONTEXT => LANG_C,
WARNING => WARN);
RETURN B;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;
/

Thanks
Hima

[cyp503]

首先谢谢zxhcloth(hima) !

但编译的时候出现错误:

Compilation errors for FUNCTION CHTFLOW.CONVERTTOBLOB

Error: PLS-00302: 必须说明 'CONVERTTOBLOB' 组件
Line: 13
Text: DBMS_LOB.convertToblob(DEST_LOB => B,


DBMS_LOB中没有这个方法,有一个CONVERTTOCLOB的方法,但参数不对

[snooper]

Insert into T1 select to_lob(Long字段) from T2

[ThomasBoxing]

dbms_lob.convertToBlob(d) from T;


我在想个问题,怎么将两个blob或bfile文件放在一起形成一个blob或bfile处理呢？
用append可以实现么？

[cyp503]

up