Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Style "PL/SQL DBMS Output" how to get line feed or carriage returns in DBMS_OUTPUT statements

User_RH51VJan 4 2023 — edited Jan 4 2023

SQL Developer
Reports -> User Defined Reports -> Edit Report -> SQL Query -> Style: PL/SQL DBMS Output
In the PL/SQL code there are multiple dbms_output statements:
Such as:
dbms_output.put_line('Running script on Server: ' || v_hostname || ' Instance: ' || v_instance || ' and Database: ' || v_database || ' ' || chr(10) || chr(13));
And:
dbms_output.put_line('OK: Database is missing ' || objCount || ' NAMED indexes of 198 Indexes used on the tables involved in The Process ');
The output does not contain carriage returns. Adding chr(10) and chr(13) has no effect.
Current Output #1:
Running script on Server: MYSERVERD01 Instance: DBINSTAA and Database: MYSPACE OK: Database is missing 0 NAMED indexes of 198 Indexes used on the tables involved in The Process
Desired Output #1:
Running script on:
Server: MYSERVERD01
Instance: DBINSTAA
Database: MYSPACE
OK: Database is missing 0 NAMED indexes of 198 Indexes used on the tables involved in The Process
Current Output #2 Example:
Running script on Server: MYSERVERD01 Instance: DBINSTAA and Database: MYSPACE ERROR: Database Missing 2 Named Indexes Missing Index SUB_GROUP_IDX1W Missing Index SUB_GROUP_IDX2W
Desired Output #2:
Running script on:
Server: MYSERVERD01
Instance: DBINSTAA
Database: MYSPACE
ERROR: Database Missing 2 Named Indexes
Missing Index SUB_GROUP_IDX1W
Missing Index SUB_GROUP_IDX2W
Oracle-communities-sql-developer-code-example.txt (2.07 KB)

This post has been answered by user_2DKLA on Jan 4 2023
Jump to Answer
Comments
Post Details
Added on Jan 4 2023
2 comments
724 views