How to enable DBMS_OUTPUT in Oracle SQL Developer for use with RSA Identity Governance & Lifecycle
Originally Published: 2016-09-30
Article Number
Applies To
RSA Version/Condition: All
Platform (DB): Oracle
Issue
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.
This RSA Knowledge Base Article explains how to enable DBMS_OUTPUT to get the query results to display.
Resolution
- Click on View on the top menu bar and then select Dbms Output from the menu.
- The Dbms Output buffer appears but is grayed out (disabled).
- Click on the green + button under the Dbms Output tab to bring up a Select Connection dialog box.
- Click on the Connection drop-down menu to select a database connection.
- Click OK when done.
- The Dbms Output tab is now enabled.
- Run the script in the example again. Note the output now displays in the Dbms Output buffer.
