After outputting several lines, TOAD starts to ignore new-lines. SQL*Plus does not seem to do that.
What happens there?
BEGIN
FOR i IN 1 .. 9 LOOP
dbms_output.put_line( 'A' );
dbms_output.new_line();
END LOOP;
END;
/
Output (new-lines missing at the last iterations):
A
A
A
A
A
A
A
A
A
Our dbms_output fetch technique changes after the first 10 lines.
Looks like a bug.
It will be fixed in the next beta.
bclark
3
Toad for Oracle Xpert (64-bit)
Add-Ons: DB Admin Module
16.3.147.1982
My system appears to be fine. Perhaps I have an option different than yours which allows mine to function as desired?
BEGIN
FOR i IN 1 .. 19 LOOP
dbms_output.put_line( 'A LineNo: '||i );
dbms_output.new_line();
END LOOP;
END;
/
--dbms output:
A LineNo: 1
A LineNo: 2
A LineNo: 3
A LineNo: 4
A LineNo: 5
A LineNo: 6
A LineNo: 7
A LineNo: 8
A LineNo: 9
A LineNo: 10
A LineNo: 11
A LineNo: 12
A LineNo: 13
A LineNo: 14
A LineNo: 15
A LineNo: 16
A LineNo: 17
A LineNo: 18
A LineNo: 19
Hi Brad,
It was fixed in between the original post and yours.
-John
bclark
5
<-- A day late and a dollar short(he sighs)
That's OK, you made up for it by including your version number.