oracle does not display output - anonymous block completed

Question

I'm trying to display a message in oracle sql develper on oracle 11g. Straight from the doc: http://www.oracle.com/technetwork/issue-archive/2011/11-mar/o21plsql-242570.html

DECLARE
  l_message  
  VARCHAR2 (100) := 'Hello World!';
BEGIN
  DBMS_OUTPUT.put_line (l_message);
END;

gives me a message:

anonymous block completed

why?

Lalit Kumar B · Accepted Answer · 2015-03-20 05:30:35Z

2

I'm trying to display a message in oracle sql develper on oracle 11g.

In SQL Developer tool, you need to view the DBMS_OUTPUT window.

enter image description here

Alternatively, you could use SET SERVEROUTPUT ON and execute the anonymous block as a script or press F5.

answered Mar 20, 2015 at 5:30

Lalit Kumar B

49.5k13 gold badges104 silver badges131 bronze badges

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

1 Answer 1