DBMS Output - text display corruption on long lines

Toad for Oracle
1

Toad for Oracle Base Edition (32-bit)
17.1.717.3711
Windows 11 Business, Version 21H2

I get corrupted display on DBMS Output tab if the line is too long and exceeds the width of the control. Moving over the line or highlighting parts of the line cause gaps to dynamically appear in text and jump around.

Font is Courier New, Regular, 7pt.

DBMS_Output_bug
DBMS_Output_bug1455×384 102 KB

DBMS_Output_bug2
DBMS_Output_bug21799×338 104 KB

DBMS_Output_bug3
DBMS_Output_bug3981×403 90.4 KB

2

Hi Paul,

I tried to reproduce it with this block of code but it looks ok to me. How does it look for you?

declare
  i number;
  j number;
  s varchar2(4000);
begin
  s := null;
  j := 0;
  i := 0;
  while i < 1000 loop
    i := i + 1;
    s := s || to_char(i);
    if length(s) > 20 then
      j := j + 1;
      if j > 20 then
        dbms_output.put_line('group' || to_char(j) || ' = ' || s || ', ');
        j := 1;
      else
        dbms_output.put('group' || to_char(j) || ' = ' || s || ', ');
      end if;
      s := null;
     end if;
  end loop;
end;

image
image1877×271 35.2 KB

3

Hi John

Yes, I get the problem. Clicked in the DBMS_Output edit box:

image
image2629×213 150 KB

4

FWiW, I cannot reproduce this effect either, using Dorlon's code, although I'm running 64-bit Toad... could this be a 32-bit issue?

image
image1322×557 73.7 KB

5

I can reproduce it on a scaled display.

6

Hi @JohnDorlon, any fix for this?

7

Hi Paul,

Not yet, sorry.

-John

8

@Paul For me, the problem goes away if you go to Options -> Editor -> Display and check "Enable font ligatures".

9

Another workaround, if you don't want to check "Enable font ligatures".
Change font to Consolas Size 10 or any of the fonts & sizes with checkmarks here

1 Like
10

Oracle Base Edition (32-bit)
Add-Ons:
24.2.208.4458

@JohnDorlon The "Enable font ligatures" checkbox seems to have disappeared in this Toad Beta, so this problem has returned for me.

I tried setting to Consolas Regular 7pt as referenced by the link, but it doesn't cure it.

11

Mike added some options to options -> Editor -> Behavior that supercede Font Ligatures.

Set Drawing Technology to "Direct Write". That does the same thing as the prior "Font Ligatures" checkbox.

I'll retest Consolas. Maybe I got my wires crossed in that table I created.

12

Hm - Consolas 7 looks good to me, but I noticed the new font dialog resets to 10 if you enter 7, hit OK, and then re-open it. I'll fix that much at least.

By the way, if your DBMS_Output window isn't sized to 100% zoom (via CTRL+Mousewheel), then all bets are off on that table.

13

Direct Write solves the issue.

What is a the reason for the strange font flickering on selection?

14

Hi Paul,

Checking "Buffered draw" should fix the flicker.

-John