Oracle provides a package, called DBMS_OUTPUT, which is specifically designed with functions for debugging PL/SQL code. It uses a buffer that your PL/SQL code writes into, and then a separate process queries the buffer out and displays the contents.
The Editor has a Right-Click menu option that will generate a DBMS_OUTPUT statement for a highlighted variable. The same menu has an option to create a blank DBMS_OUTPUT statement.
To generate an output line from a variable
Right-click and select Output Statements | Make Output Statement.
Note: The statement is created on the clipboard.
To generate a blank output statement
To view DBMS Output
On the main toolbar, select View | DBMS Output.
DBMS_OUTPUT results only display after the procedure has completed execution, not while you are single stepping through the code. In nested procedure calls, all procedures must have run to completion before any DBMS Output content is displayed.
You can easily execute a SQL statement embedded within PL/SQL. Toad extracts the SQL statement and adjusts the syntax as necessary. Any identifier which is not a column of a referenced object is treated as a bind variable. If the identifier is a reference to a PL/SQL constant, the bind variable value defaults to the constant value.
To execute a SQL statement within PL/SQL
Place the cursor in the statement and press SHIFT+F9. A new window displays with the extracted SQL statement.
You can execute stored procedures, functions, packages or triggers in the Schema Browser or in the Editor.
To execute stored code from the Schema Browser
To execute stored code from the Editor
Toad provides an intuitive and efficient way to write, run, and test your SQL and PL/SQL code. Toad supports efficient code management for a single developer or a whole team of developers.