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/，如需轉載，請註明出處，否則將追究法律責任。