Toad World® Forums

dbms_output just comes out once


DBMS_OUTPUT.put_line (‘aaa’);
DBMS_OUTPUT.put_line (‘bbb’);
DBMS_OUTPUT.put_line (‘ccc’);

Just gives a single output in Spool Tab:

Database: Oracle Database 11g Enterprise Edition Release - 64bit
Client: Win 7 64-bit
(Beta Build

With nav 6.3 it works fine.


I had a quick look and it displays all 3 rows for me.
Is it possible you have the preference for Default Rows Displayed set to 1

It is under View\Preference\Code Editor\SQL Scripts\Spool Output\Default Rows Displayed



No, I have a value 5 in there just like you.
I even did a complete reset and restarted sqlnav and it didn’t help -> still a single line comes out.


Ok, now I have new machine. The same OS though.
The bug does not appear anymore.