Bug Report: SQL Window print

[ScottMattes]

I have had to print some queries lately and notice that lines are being dropped between pages. I can even recreate it at will.

Run this query

select rownum
from all_objects;

copy the first 200 rows of the result into the clipboard and paste it into a new SQL Window, then print it. I lost 1 line between each page.

I have these print options set
General
show print dialog
print line numbers
wrap lines while printing
print sql text in sql window

Grid
print lines
inverted heading

Header
caption
date

Footer
page numbers

If I change the window to a Command Window the same thing happens

 

[Marco Kalter]

Can you check that your page setup (File > Page setup) does not exceed the physically printable area of page?

 

[ScottMattes]

File > Print Setup says 8.5 x 11, which is what I am printing on.

For single page size queries I see just the divider line of the footer, but no page number.

For multiple page size queries I do not see the divider line.

 

[John Wallmark]

I have also had this problem in 7.0 and 7.1 in the SQL window. In 7.1 I also have it in the Program window. Fiddling with Page Setup has not helped. Is there a fix yet for this?

 

[Marco Kalter]

I cannot reproduce such an error. Can you send me your printer and page info?

 

[John Wallmark]

It looks like it may be printer specific. I had the problem with an HP Office Jet 7310. Today I am at another site, connected to a Konica Minolta bizhub 8031, and printing worked fine in both the SQL and program windows. This time I got the page numbers at the bottom and no lost lines.

Print Setup in PL/SQL Dev was Portrait and Letter size for both printers. Page Setup was Portrait, Letter size, margins Left=0.5, Right=0.2, Top=0.3, Bottom=0.3 (the defaults).

Currently on PL/SQL Developer Version 7.1.1.1339.

Tomorrow I will try updating the printer driver for the HP printer.