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!

User Defined Reports for Style "PL/SQL DBMS Output" does not allow new line feed

User_A36HOApr 20 2016 — edited Apr 20 2016

I have created a simple User Defined Report with style "PL/SQL DBMS Output" like this:

++++++++++++++++

DECLARE

v_object_owner varchar2(30):='N/A';

BEGIN

dbms_output.put_line('Adding Object_Owner , Starting execution at: '||TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));

---

dbms_output.put_line('==>');

---

--v_object_owner := :OBJECT_OWNER;

---

dbms_output.put_line('Passing Parameter: '||v_object_owner);

---

dbms_output.put_line('==>');

---

NULL;

---

dbms_output.put_line('SUCCESS & Ended execution at: '||TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));

END;

++++++++++++++++++++++

My problem is that the output is printed on the same line.

I have tried CHR(10) and CHR(13) in different variations.

Still not able to get the new line feed.

Please help me out.

Best regards,

vr

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2016
Added on Apr 20 2016
10 comments
2,058 views