Home » SQL & PL/SQL » SQL & PL/SQL » Problem in spooling a file.
Problem in spooling a file. [message #412322] Wed, 08 July 2009 12:17 Go to next message
vinesh gupta
Messages: 4
Registered: August 2002
Junior Member
Hello ,

I am having some problem in spooling a file i am using a single script that connect to different user to fetch a data i am using html to spool a file.
whenever it connect to different user it show message "connected " in spool file .
Is their any method to remove this message coming in spool file .

with regards

Vinesh
Re: Problem in spooling a file. [message #412326 is a reply to message #412322] Wed, 08 July 2009 12:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way but close spool and reopen append the file using "spool append" if you are in an appropriate version which you didn't post when it is requested.
Please read OraFAQ Forum Guide.

Regards
Michel

[Updated on: Wed, 08 July 2009 12:42]

Report message to a moderator

Re: Problem in spooling a file. [message #412332 is a reply to message #412322] Wed, 08 July 2009 13:16 Go to previous messageGo to next message
vinesh gupta
Messages: 4
Registered: August 2002
Junior Member

I am using oracle 9i and is using html to spool a file it show
error"SP2-0333: Illegal spool file name: "C:\Temp\vinesh.xls APPEND" (bad character: ' ')"

when i again try to open it i am using xls format to save it.


With Thanks
Vinesh Gupta
Re: Problem in spooling a file. [message #412335 is a reply to message #412332] Wed, 08 July 2009 13:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"append" is available in 10g and up.

Regards
Michel
Re: Problem in spooling a file. [message #412355 is a reply to message #412322] Wed, 08 July 2009 20:18 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>error"SP2-0333: Illegal spool file name: "C:\Temp\vinesh.xls APPEND" (bad character: ' ')"
You could user USER as part of spool file name & then append the files with Operating System command as the final operation of SQL file.
Previous Topic: replace the character based on the positions (merged)
Next Topic: Help Required for Order By Clause
Goto Forum:
  


Current Time: Sat Dec 10 20:31:06 CST 2016

Total time taken to generate the page: 0.07444 seconds