Question

我在PLSQL中用dbms_output.put_line打印消息，请问能在PLSQL中看到我输出的消息吗？如果能怎么样能看到？

declare
v_yhid tb_gg_yhxx.f_yh_id %type := 11111111111;
begin
update tb_gg_yhxx set f_yh_name = 'test' where f_yh_id = v_yhid;
if SQl%found then
dbms_output.put_line(SQL%rowcount || 'Delete Ok!');
end if;
if SQL%notfound then
dbms_output.put_line('雇员编号' || v_yhid || '不存在');
end if;
end;网上查资料说用set serveroutput on;我试了可是不行啊。报【ORA-00922 缺少或无效选项】，请各位大侠帮忙。。先谢过~~

Answer 1

set serveroutput on;declare
v_yhid tb_gg_yhxx.f_yh_id %type := 11111111111;
begin
update tb_gg_yhxx set f_yh_name = 'test' where f_yh_id = v_yhid;
if SQl%found then
dbms_output.put_line(SQL%rowcount || 'Delete Ok!');
end if;
if SQL%notfound then
dbms_output.put_line('雇员编号' || v_yhid || '不存在');
end if;
end;试试看