Toad World® Forums

dbms_output just comes out once


#1

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

Just gives a single output in Spool Tab:
“aaa”

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

With nav 6.3 it works fine.


#2

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

regards
Lidia


#3

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.


#4

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