Home » SQL & PL/SQL » Client Tools » spool adds lines to each record
spool adds lines to each record [message #273215] Tue, 09 October 2007 10:01 Go to next message
lmayer
Messages: 8
Registered: December 2006
Junior Member
Morning,

I have a spool file that has three select statements the 1st sets the header record the second creates 5 lines of information. The last statement creates the trailer record. The problem is I can have a header one line and a trailer with no problem like so

HR
01
TR

But when I add the another line I get a space between the next record and the TR record. Like this:

HR
01
02

TR

I've tried multiple combinations of the 5 lines, 01,02TR 02,03TR ect ect. and the same thing happens.

I've set the commands ate the top like so:

set termout off
set pagesize 0
set linesize 600
set newpage 0
set verify off
set echo off
set heading off
set feedback off

Can anyone help me with this?

Thanks in advance.

Laura

Re: spool adds lines to each record [message #273223 is a reply to message #273215] Tue, 09 October 2007 10:44 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Post your spool file and the script.

By
Vamsi
Re: spool adds lines to each record [message #273224 is a reply to message #273223] Tue, 09 October 2007 10:49 Go to previous messageGo to next message
lmayer
Messages: 8
Registered: December 2006
Junior Member
Here is the spooled file.

Re: spool adds lines to each record [message #273226 is a reply to message #273224] Tue, 09 October 2007 10:50 Go to previous messageGo to next message
lmayer
Messages: 8
Registered: December 2006
Junior Member
Here is the script.

Thanks for looking.

Laura
  • Attachment: test3.sql
    (Size: 5.49KB, Downloaded 275 times)
Re: spool adds lines to each record [message #273230 is a reply to message #273215] Tue, 09 October 2007 11:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set recsep off

Regards
Michel
Re: spool adds lines to each record [message #273231 is a reply to message #273230] Tue, 09 October 2007 11:02 Go to previous message
lmayer
Messages: 8
Registered: December 2006
Junior Member
Perfect!!!

Thank you so much.

Laura
Previous Topic: SQL Developer Issue: DELETE key stopped working?
Next Topic: TOAD - Compare Schema's - CLOB/BLOB
Goto Forum:
  


Current Time: Sat Dec 10 05:00:41 CST 2016

Total time taken to generate the page: 0.09081 seconds