DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: blank pages on report

  1. #1
    Join Date
    Aug 2000
    Posts
    163

    Wink

    Hello,
    I've developed a sqlplus report. Before I do my major select statement I do two selects serving for retrieving sysdate and db instance which I use in my btitle and ttitle. I do serverouput off before those two selects and serveroutput on after they took place. The report looks pretty good on my computer monitor. The problem is when I look at the spooled report it contains two blank pages(I assume one for each little select I am using) with ttitle and btitle on them. Only after two blank pages are created then my main report information is displayed.
    Please help me to get rid of those two unnedded pages.

  2. #2
    Join Date
    Mar 2001
    Posts
    2
    Mary,

    Don't issue your spool <filename> command till just before your final select (i.e. the real one)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width