Capture SQL/Developer Script Output in PL/SQL

Question

在SQL/Developer中，当我执行语句时，我得到一个脚本输出消息，读取类似于7 Records Merged

这是我相关的PL/SQL代码:

v_sql_loader := 'merge into foobar b using foobiz i on (b.foobar_id = i.foobiz_id) when not matched then insert (foobar_id) values (foobiz_id)';

execute immediate v_sql_loader;

如何在PL/SQL中捕获7 records Merged?

我正在写dbms_output.put_line(SQLERRM)，但这只返回ORA-0000: normal, successful completion

我可以使用什么Oracle/PLSQL对象来复制SQL/Developer Script输出消息?期望结果:PLSQL语句，最好是dbms_output.put_line();表示7 Records Merged.

Answer 1

使用SQL%ROWCOUNT:

BEGIN
...
EXECUTE IMMEDIATE v_sql_loader;
DBMS_OUTPUT.PUT_LINE('Merged: ' || SQL%ROWCOUNT);
END;
/