DBMS_OUTPUT.put_line in procedure

Question

I have many DBMS_OUTPUT.put_line in a procedure, but when I launch it I only have this message in the SQL Developer console :

anonymous block completed

This is how I launch my procedure :

BEGIN
  MY_PROCEDURE();
  commit;
END;

How to fix that ?

@Allan Indeed, the `SET SERVEROUTPUT ON` was missing. It works. Thanks. — BnJ, Oct 20 '14 at 15:45

score 1 · Accepted Answer · answered Oct 20 '14 at 15:47

1

I forgot SET SERVEROUTPUT ON...

It works :

SET SERVEROUTPUT ON;
BEGIN
  MY_PROCEDURE();
  commit; 
END;

answered Oct 20 '14 at 15:47

BnJ

1

you can also open the DBMS_OUTPUT panel under the View menu and enable polling for your connections – thatjeffsmith Oct 20 '14 at 16:53

1 Answers1