page numbers missing from SQL Window print

Ken Frohne

Member
Hi,
When I print from the SQL Window, the page number only appears on the last page of the output. I have tried changing the Printing options in the Preferences dialog, but still can't get the page numbers to appear anywhere but the last page. I think this is a bug - can anyone confirm this? I am using version 5.1.6.747 of PL/SQL Developer.

Thanks,
Ken
 
I tested this, but I get a page number on each page. Is this reproducible with any kind of query? Can you let me know your other printing preference settings?
 
I have noticed this too, but haven't cared enough.

I can reproduce it for every query that goes beyond one page. Could it have to do with Letter vs. A4?
 
Is your Page Setup correctly (File > Page Setup)? I can only imagine that the page number falls outside the physical page area.
 
I'm not sure that it's the page setup. I've tried 1.5 inch margins and it still happens. I'm using 8.5 X 11 paper (letter size). I don't really see anything else to adjust.

For me, if the SQL statement is less than 1 page long with several hundred rows selected, it works great. The grid prints with page numbers on all pages.

If the SQL statement is longer than 1 page long, it skips the page numbers until the last page.

Mike
 
Hy,

same problem with A4.
Try 50 time a
------------
SELECT 1 FROM dual
UNION
------------
and execute this, after that print it.
on the first page isn't a page number.
 
Back
Top