CODEWITHSUNDEEP
sqlsqlplusspoolfixed-length-file
user321068
user321068

Reputation:

sqlplus spooling: How to get rid of first, empty line?

I'm doing the following spooling statement:

SET VERIFY OFF
SET FEEDBACK OFF
SET HEADING OFF
SET TRIMSPOOL ON
SET TERM OFF
SPOOL &pathRelations
START scripts/relations.sql &parent
SPOOL OFF
SET TERM ON

The scripts/relations.sql file contains a simple select statement.

Unfortunately, the spooled file contains an empty line as the first one in the file. This line causes trouble in our framework.

Of course I could get rid of these line through sed but ain't there a way to suppress its creation in the first place?

Upvotes: 26

Views: 52449

Answers (4)

bryc3monk3y
bryc3monk3y

Reputation: 464

Working in TOAD, set newpage none didn't work for me. I still had an empty row between the header and the data. However, when I removed set trimspool on, the empty row went away.

Upvotes: 0

Papacuku
Papacuku

Reputation: 11

FYI set newpage does nothing if using set markup csv on. Set markup csv on creates an LFCR at the beginning of the file which excel uses and adds a blank row.

Upvotes: 1

Tagar
Tagar

Reputation: 14891

SET NEWPAGE NONE is the correct answer.

SET NEWPAGE 0 will cause a page feed, which is not what the OP wants.

Upvotes: 47

user321068
user321068

Reputation: 

SET NEWPAGE 0

see here

Upvotes: -1

Related Questions