CODEWITHSUNDEEP
oracle-database
max
max

Reputation: 10454

oracle does not display output - anonymous block completed

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?

Upvotes: 0

Views: 3716

Answers (1)

Lalit Kumar B
Lalit Kumar B

Reputation: 49082

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.

Upvotes: 2

Related Questions