How to set and view DBMS OUTPUT of Oralce in TOAD
To open the DBMS Output window in TOAD, go to View > DBMS output.
To test if it is working or not use the following procedure in TOAD sql editor and execute it.
Have a look at the image displayed under. Write the SQL mention above into an SQL editor and press Execute Statement button after selecting the entire sql.
Once you execute the above sql, open the output window to see the output. See the image below.
Filed under: Oracle, TOAD, Tutorials | 3 Comments
Tags: dbms output, TOAD, X dbms_output, X dbms_output.put_line, X oralce output