create table t(id int,content clob);CREATE OR REPLACE PROCEDURE test_pro(v_a CLOB) AS BEGIN INSERT INTO t(id,content)VALUES(1,empty_clob()); UPDATE t SET content=v_a WHERE id=1; END;SQL> exec test_pro('你好');
SQL> select * from t;
ID CONTENT --------------------------------------- -------------------------------------------------------------------------------- 1 你好
wf@ORA10> create table t(id int,c clob);表已创建。wf@ORA10> select * from t;未选定行wf@ORA10> insert into t values(1,'ff');已创建 1 行。wf@ORA10> select * from t; ID C ---------- ------------------------------------------------------- 1 ffwf@ORA10>
wf@ORA10> update t set c='wf' where id=1;已更新 1 行。wf@ORA10> select * from t; ID C ---------- ------------------------------------------------ 1 wf
AS
BEGIN
INSERT INTO t(id,content)VALUES(1,empty_clob());
UPDATE t SET content=v_a WHERE id=1;
END;SQL> exec test_pro('你好');
SQL> select * from t;
ID CONTENT
--------------------------------------- --------------------------------------------------------------------------------
1 你好
---------- -------------------------------------------------------
1 ffwf@ORA10>
---------- ------------------------------------------------
1 wf