Since our company upgraded our version of Oracle SQL Developer, I've been noticing issues when outputting data to the DBMS_OUTPUT using DBMS_OUTPUT.PUT_LINE.
We use this function and combine it with the text-to-columns feature in Excel to quickly generate reports. However, I've found that since the update, text is forcing a line break in the DBMS_OUTPUT (seemingly) randomly. This is detrimental to the report generating as it relies on perfect alignment with a spread sheet template.
I'm uncertain what is causing this line break but to demonstrate I have supplied a messy but hopefully useful example below.
If I run the below statement 22 times as an example:
begin
DBMS_OUTPUT.PUT_LINE('111111111111111111111111111111111111111111111111111111111111111111111111111');
end;
We would expect the output to return 75 1's in a row, 22 times. However, this is not the case. On lines 11 and 12, the following is returned:
11
1111111111111111111111111111111111111111111111111111111111111111111111111
(the above displays 2 1's on line 11 and 73 on line 12)
again on lines 22 and 23
111
111111111111111111111111111111111111111111111111111111111111111111111111
(the above displays 3 1's on line 11 and 72 on line 12)
As you can see, the line is breaking at line 11 and line 22.
It should be noted that all other lines are formatted correctly, it is only the text on lines 11 and 22 that is wrapping/breaking
Of course this is not a valid real world example but I thought it was the easiest way of explaining it.
Does anybody has any ideas as to why the lines are wrapping and how I can fix it?