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.

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.
 
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


 

Attachments

    Outcomes