DECLARE
IN_XMLINFO CLOB := '1';
v_Clob CLOB;
BEGIN
DELETE FROM pl_clob;
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-759638/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11990065/viewspace-759638/