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;
How could I make Toad auto shows PL\SQL output? Thanks
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With