12-3. Enabling Output to Be Displayed
Problem
You want to display the results of DBMS_OUTPUT
within Oracle SQL Developer.
Solution
Enable DBMS_OUTPUT
for your connection via the Dbms Output
pane. This pane resides on the lower-right side of the IDE. Do so by selecting the green plus icon within the pane and then choosing the desired connection from the resulting dialog box. Figure 12-6 shows the connection dialog box. After selecting the desired connection and then clicking the OK button, you will be prompted for a password for the connection if you are not already connected. Once a successful password has been entered, then DBMS_OUTPUT
will be enabled for the specified connection.
Figure 12-6. Select Connection dialog box
After enabling ...
Get Oracle and PL/SQL Recipes: A Problem-Solution Approach 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.