Re: SQL Plus spooling problem [message #370465] |
Wed, 24 November 1999 18:51 |
Paul
Messages: 164 Registered: April 1999
|
Senior Member |
|
|
Only time I ever had this happen was when I attempted to spool to a floppy with a lot of stuff already on it and didn't have enough room for the spooled file. I'm assuming that if you are spooling multiple reports produced by a single SQL script to individual files, that you are issuing a SPOOL OFF before you issue another SPOOL path\filename.ext -- if not, this could be the problem. The UNIONs should not cause any problem, I've got several SQL reports that contain multiple UNIONs that spool without any problem.
|
|
|