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!

[4.2EA] extra newlines sometimes added to dbms_output

B.DelméeSep 27 2016 — edited Apr 27 2017

i have noticed that the output of one of my scripts contains extra newlines when run under 4.2.

This is a script that collects ALL_VIEWS.TEXT for a couple development schemas (600+ views) in a text file.

It produces 64k+ lines, and is a valid (if huge) script with comments and "create view xxx as ..." statements.

Under 4.2, the output is broken as an extra newline is sometimes added in the middle of a comment, introducing invalid statements.

The broken lines are not necessarily the longest ones, either.

i could not  produce a simplified test case so far,but perhaps some users have observed this behaviour, too ?

On the bright side, i was using the output of that script to feed the formater,

and had not noticed the extra newlines which caused failures to format (invalid) code.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2017
Added on Sep 27 2016
18 comments
2,064 views