Home » RDBMS Server » Server Administration » Re: SQL Plus spooling problem
Re: SQL Plus spooling problem [message #370465] Wed, 24 November 1999 18:51
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.
Previous Topic: writing large records to output files
Next Topic: Ugrading to oracle 8
Goto Forum:

Current Time: Tue Dec 06 19:12:12 CST 2022