Oracle:使用Toad设置SERVEROUTPUT ON [英] Oracle: SET SERVEROUTPUT ON with Toad

问题描述

我将 SET SERVEROUTPUT设置为大小无限的格式；在 glogin.sql 中，但 Toad 似乎没有采用此配置.换句话说，以下PL \ SQL无法显示输出:

I put SET SERVEROUTPUT ON SIZE UNLIMITED FORMAT WRAPPED; in glogin.sql, but Toad doesn't seem to take this configuration. In other words, the following PL\SQL wpuldn't print output:

BEGIN
    DBMS_OUTPUT.PUT_LINE('Hello World');
END;

如何使Toad自动显示PL \ SQL输出? 谢谢

How could I make Toad auto shows PL\SQL output? Thanks

推荐答案

glogin.sql是由SQL Plus自动运行的脚本.据我所知，Toad没有运行此脚本.在Toad中，编辑器"窗口底部有一个"DBMS输出"窗格，在窗格的左上方有一个红色按钮以打开输出.

glogin.sql is a script run automatically by SQL Plus; as far as I'm aware Toad does not run this script. In Toad there is a "DBMS Output" pane at the bottom of the Editor window, and a red button at the top left of the pane to turn output on.

这篇关于Oracle:使用Toad设置SERVEROUTPUT ON的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！