Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SET SERVEROUTPUT ON not working in SQL Developer 4.1

Mani-OracleJul 20 2015 — edited Nov 20 2015

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 ;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2015
Added on Jul 20 2015
11 comments
16,607 views