OraFAQ Forum: Server Administration » Report prints one blank page at the beginning

Home » RDBMS Server » Server Administration » Report prints one blank page at the beginning

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Report prints one blank page at the beginning [message #371768]

Mon, 04 December 2000 09:01

M. Buxton
Messages: 2
Registered: December 2000

Junior Member

I'm using Oracle 7 and the output sent to the spool file from my sql query has a blank page at the beginning of the report. Any ideas?

Report message to a moderator

Re: Report prints one blank page at the beginning [message #371769 is a reply to message #371768]

Mon, 04 December 2000 09:16

Brent Stayer
Messages: 6
Registered: October 2000

Junior Member

I put similar to the following without any problems with a blank page.
Hope this helps.
Brent

CLEAR BREAKS;
CLEAR COLUMNS;
CLEAR COMPUTES;
SET PAGESIZE 60;
SET LINESIZE 132;
SET NEWPAGE 0;
SET VERIFY OFF;
SET PAUSE OFF;
SPOOL OUTPUT;

Report message to a moderator

Re: Report prints one blank page at the beginning [message #374804 is a reply to message #371769]

Tue, 03 July 2001 13:36

Gail
Messages: 3
Registered: July 2001

Junior Member

A side effect of this method puts ^L in the 1st 2 positions.
We need to produce output without the blank line as 1st record and without the extra characters.
Any suggestions ?

Report message to a moderator

Previous Topic:	Oracle Service...
Next Topic:	find salary

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 04:20:25 CDT 2024