Using DBMS_OUTPUT
DBMS output is the main output from PL/SQL. You can use DBMS_OUTPUT to format print lines, display data (as we did with the TEMPERATURE_CONVERSION procedure), and display error conditions. This was a popular technique to display information when debugging code. It is referenced here to illustrate how easy it is to add these statements for debugging or other purposes.
Right-click on the code and select Make Output Statement (as illustrated in Figure 4.42). Put the cursor in the code where you want to put the DBMS_OUTPUT statement and paste (Ctrl+V). Fill in the text that you would like to see in the DBMS_OUTPUT tab after execution as illustrated in Figure 4.43.
Figure 4.42. Accessing the DBMS_OUTPUT blank statement.
Figure ...
Get TOAD® Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.