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

Document created by RSA Customer Support Employee on Oct 4, 2016Last modified by RSA Customer Support on Aug 27, 2020
Version 6Show Document
  • View in full screen mode

Article Content

Article Number000034118
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: All
Platform (DB): Oracle
IssueThis 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.

report CLOB;

report :=  SRSection_System.Database('Database Summary');
report :=   SRSection_System.Product('Product Version');

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

This RSA Knowledge Base Article explains how to enable DBMS_OUTPUT to get the query results to display.
ResolutionFollow 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.

     User-added image

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

     User-added image

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

      User-added image

  1. The Dbms Output tab is now enabled.

      User-added image

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

      User-added image