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

  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