clob处理

 

如果是很大，则可以考虑：

http://yangtingkun.itpub.net/post/468/495918

create table PL_CLOB
(
  id      INTEGER not null,
  type    VARCHAR2(1) not null,
  content CLOB
);

declare
 IN_XMLINFO clob:='hah';
 v_Clob CLOB;
 begin
  
insert into PL_CLOB (ID, TYPE, CONTENT)
values (1, '1', EMPTY_CLOB)
RETURNING CONTENT INTO v_Clob;

IF IN_XMLINFO IS NOT NULL THEN
            DBMS_LOB.WRITE(v_Clob,
                           DBMS_LOB.GETLENGTH(IN_XMLINFO),
                           1,
                           IN_XMLINFO);
        END IF;
   
        COMMIT;

end;
/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11990065/viewspace-756707/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11990065/viewspace-756707/