DBMS OUTPUT doesn't work

Question

I need a piece of advice there. I'm using Oracle Developer for a few anonymous PL/SQL blocks. The problem is that when I run it, the dbms_output don't give me anything even though the script is correct (anonymous block completed).

What is wrong? What am I missing? I already enabled the dbms_output connection and the test seems to be ok.

set serveroutput on size 30000;

DECLARE
  CURSOR my_curs IS 
     SELECT studenti.nume, 
            studenti.prenume, 
            studenti.an, 
            note_studenti.nota, 
            obiecte.den 
       FROM studenti 
      INNER JOIN  note_studenti 
         ON studenti.mat = note_studenti.mat 
      INNER JOIN  obiecte 
         ON note_studenti.cod = obiecte.cod;

  v_nume     studenti.nume%TYPE;
  v_prenume  studenti.prenume%TYPE;
  v_an       studenti.an%TYPE;
  v_nota     note_studenti.nota%TYPE;
  v_ob       obiecte.den%TYPE;
BEGIN 
  OPEN my_curs;
  LOOP 
    FETCH my_curs INTO v_nume, v_prenume, v_an, v_nota, v_ob;
    EXIT WHEN my_curs%NOTFOUND;
    DBMS_OUTPUT.PUT_LINE( v_nume || ' '   || v_prenume ||
                        ' este in anul '  || v_an      ||
                        ' si a luat nota '|| v_nota    || 
                        ' la obiectul '   || v_ob);
  END LOOP;
END;

Answer 1

Just to make sure.... Does the cursor query fetch any data? The DBMS_Output will not output anything if there is no data!

Answer 2

I’m using SQL developer too and I have the same issue , but it works fine in the SQL workshop in the web browser. So give it a try.