create or replace function testclob return clob
as
v_clob clob;
s varchar2(1000);
begin
s:='1111';
dbms_lob.createtemporary(v_clob,FALSE,DBMS_LOB.CALL);
dbms_lob.open(v_clob,dbms_lob.lob_readwrite);
dbms_lob.writeAppend( v_clob, length(s), s ); dbms_lob.close(v_clob);
return v_clob;
end;
我执行的时候会报 ORA-03127 :在活动操作结束之前不允许进行新的操作
as
v_clob clob;
s varchar2(1000);
begin
s:='1111';
dbms_lob.createtemporary(v_clob,FALSE,DBMS_LOB.CALL);
dbms_lob.open(v_clob,dbms_lob.lob_readwrite);
dbms_lob.writeAppend( v_clob, length(s), s ); dbms_lob.close(v_clob);
return v_clob;
end;
我执行的时候会报 ORA-03127 :在活动操作结束之前不允许进行新的操作
加一个commit,自己提交事务!