当PLSQL Anonymous块完成时，为什么没有输出? [英] Why no output when PLSQL Anonymous block completes?

问题描述

我刚刚进入PL/SQL，并尝试运行以下代码，并且匿名块已完成，但是我认为我应该得到 Testing output .有人知道我在做什么错吗?

I'm just getting into PL/SQL, and I tried to run the following code, and I am getting anonymous block completed, but I think I should be getting Testing output. Does any know what I am doing wrong?

DECLARE
   message varchar2(20) := 'Testing output';
BEGIN
   dbms_output.put_line(message);
END;
/

推荐答案

查看DBMS_OUTPUT取决于程序.

Viewing the DBMS_OUTPUT depends on the program.

SQL * Plus和Oracle SQL Developer

首先运行SET SERVEROUTPUT ON;.这是SQL * Plus或最新版本的Oracle SQL Developer所必需的.

Run SET SERVEROUTPUT ON; first. This is all that's necessary in SQL*Plus or recent versions of Oracle SQL Developer.

SET SERVEROUTPUT ON;
begin
    dbms_output.put_line('Testing output');
end;
/

PL/SQL Developer

自动检测到输出并显示在输出"选项卡中.

Output is automatically detected and displayed in the "Output" tab.

这篇关于当PLSQL Anonymous块完成时，为什么没有输出?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！