OraFAQ Forum: Client Tools » sqlplus && DBMS_OUTPUT.PUT

Home » Other » Client Tools » sqlplus && DBMS_OUTPUT.PUT_LINE doesn't work ? (Oracle 12.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlplus && DBMS_OUTPUT.PUT_LINE doesn't work ? [message #678680]

Fri, 27 December 2019 05:59

a100
Messages: 34
Registered: March 2019

Member

Hello all,
I am learning how to use DBMS_OUTPUT.PUT_LINE (it is supposed to be a simple isn't it ?) but when I run this query saved in file test_dual.sql:

DECLARE
  RES      VARCHAR2(50);
BEGIN
  SELECT 3+4 INTO RES FROM DUAL;
  DBMS_OUTPUT.PUT_LINE(RES);
END;

I get the following result:

SQL> @test_dual;
  7  /

PL/SQL procedure successfully completed.

Where is the real output of this ?

Report message to a moderator

Re: sqlplus && DBMS_OUTPUT.PUT_LINE doesn't work ? [message #678682 is a reply to message #678680]

Fri, 27 December 2019 06:17

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> DECLARE
  2    RES      VARCHAR2(50);
  3  BEGIN
  4    SELECT 3+4 INTO RES FROM DUAL;
  5    DBMS_OUTPUT.PUT_LINE(RES);
  6  END;
  7  /

PL/SQL procedure successfully completed.

SQL> set serveroutput on
SQL> /
7

PL/SQL procedure successfully completed.

Report message to a moderator