How to enable DBMS_OUTPUT in Oracle SQL Developer for use with RSA Identity Governance & Lifecycle

[#1]

Article Number

000034118

Applies To

RSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: All
Platform (DB): Oracle
 

Issue

This RSA Knowledge Base Article explains how to enable DBMS_OUTPUT in Oracle SQL Developer. 

For example, you have the following PL/SQL script that writes to DBMS_OUTPUT.

DECLARE
report CLOB;

begin 
report :=  SRSection_System.Database('Database Summary');
DBMS_OUTPUT.PUT_LINE(report);
report :=   SRSection_System.Product('Product Version');
DBMS_OUTPUT.PUT_LINE(report);
end;

But when you run the script, the DBMS_OUTPUT is not displayed. The following script is executed as AVUSER.
 

Image description

This RSA Knowledge Base Article explains how to enable DBMS_OUTPUT to get the query results to display.
 

Resolution

Follow these steps to enable DBMS_OUTPUT in Oracle SQL Developer:

1. Click on View on the top menu bar and then select Dbms Output from the menu.

     Image description
 

2. The Dbms Output buffer appears but is grayed out (disabled).

     Image description

3. Click on the green + button under the Dbms Output tab to bring up a Select Connection dialog box.  
4. Click on the Connection drop-down menu to select a database connection.
5. Click OK when done.

      Image description

6. The Dbms Output tab is now enabled.

      Image description

7. Run the script in the example again. Note the output now displays in the Dbms Output buffer.

      Image description