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 你好
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 你好