-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|