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