000034118 - How to enable DBMS OUTPUT in Oracle SQL Developer for RSA Identity Governance and Lifecycle

Document created by RSA Customer Support Employee on Oct 4, 2016•Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 4Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000034118
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Product/Service Type: Appliance
RSA Version/Condition: All version
Database: Oracle
IssueAfter running the following script, as shown below, using the DBMS_OUTPUT command in Oracle SQL Developer not result is found, as in the screenshot below.
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;

 
User-added image

This occurs because the DBMS_OUTPUT is not available.
 
ResolutionThere are 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 tab appears on the right hand side and under the Script Output tab but it is disabled.
     User-added image

  1. Click on the + button under the Dbms Output tab to bring up a Select Connection dialog box.  
  2. Click on the dropdown box to select the correct database to make a connection.
  3. Click OK when done.
      User-added image

  1. The Dbms Output tab now is enabled.
      User-added image

  1. Run the script shown in the Issue field above using DBMS_OUTPUT again. The outcome will show on the area of Dbms Output tab.
      User-added image

Attachments

    Outcomes