Oct 242013
 

Printing messages in the console working with SQL Developer is done in the following way:

  1. In the tab Dbms Output choose:
    dbms-out-console-enable
  2. Chose the connection:
    dbms-out-select-connection
  3. Running a small test:
    DECLARE
    BEGIN
      DBMS_OUTPUT.PUT_LINE('boo');
    END;
    /
    

Съответно нашия низ бива отпечатан в конзолните прозорци Script Output и Dbms Output:

anonymous block completed
boo
Share