PL/SQL, Cannot print variable

Question

I'm trying to learn PL/SQL by simply assigning a variable from a select statement and then, to confirm it's working, print it sql output.

DECLARE ALLOW_STUFF NUMBER;
BEGIN
   SELECT VAL_N INTO ALLOW_STUFF FROM MY_TABLE WHERE MY_KEY = 'ALLOW_ME';
   DBMS_OUTPUT.PUT_LINE(ALLOW_STUFF);
END;

I'm using SQL Developer and/or SQL PLus. When I run this, all I get is

Anonymous block completed

Rather than than the value of MY_TABLE.VAL_N

set serveroutput on docs.oracle.com/cd/E11882_01/server.112/e16604/… — user330315
– user330315, Commented Mar 5, 2014 at 17:59

Aivis · Accepted Answer · 2014-03-05 18:06:22Z

3

You need to enable output, otherwise the DBMS_OUTPUT.PUT_LINE statements are ignored. Output can be enabled using:

DBMS_OUTPUT.ENABLE();

For more information about DBMS_OUTPUT read Oracle documentation: http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_output.htm#i1000634

As stated in the comments also set serveroutput on can be used.

edited Mar 5, 2014 at 18:06

answered Mar 5, 2014 at 17:57

Aivis

1213 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Lurk21 Over a year ago

Tried that - same result.

tvm Over a year ago

Did you connect the DBMS output windows in SQLDeveloper? DBMS output won't appear in the ordinary script output window.

Lurk21 Over a year ago

I had to also add set serveroutput on size 30000;

Collectives™ on Stack Overflow

PL/SQL, Cannot print variable

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related