11 Replies Latest reply on Nov 20, 2015 1:41 PM by thatJeffSmith-Oracle

    SET SERVEROUTPUT ON not working in SQL Developer 4.1

    Mani-Oracle

      In SQL Developer 3.2 & 4.0.3.16.84 SET SERVEROUTPUT ON & DBMS_OUTPUT.PUT_LINE works fine. Now in SQL Developer 4.1 it is NOT working. We have below stored procedure.

      CREATE OR REPLACE PROCEDURE procedure1 AS
      BEGIN
      DBMS_OUTPUT.PUT_LINE('aaaa');
      END PROCEDURE1;

      When we run this procedure from the run procedure pane SQL Developer just says:
      Connecting to the database xxxx.
        Process exited.
        Disconnecting from the database xxxx.
       

      NO OUTPUT!!!

      When we run from worksheet it show sPL/SQL procedure successfully completed.

      BEGIN
      DBMS_OUTPUT.PUT_LINE('aaaa');
      END ;