how to enable output in Oracle SQL Developer

Sep 6, 2010 | oracle pl/sql

To enable output to console window in Oracle SQL Developer (as of 2.1.1.64)

  1. From the menu go to: View > Dbms Output
  2. From the new window (popped-up in the log area) click on the plus sign to enable output
  3. Enter the output you want i.e.:
    [sql]DBMS_OUTPUT.PUT_LINE(‘CLA_CLA_ID: ‘ || V_ASY_CLA_ID2 || ‘, ‘ ||V_ASY_SURNAME2);[/sql]
  4. This should display when SQL code is run