Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Write to a text file from a stored procedure 1

Status
Not open for further replies.

madlarry

Programmer
Dec 6, 2000
117
GB
Hi,

Is it possible to write to a text file from within a stored procedure for both SQL Server and Oracle ????

Thanks,

Madlarry
 
I don't use Oracle but it has a SPOOL command for this purpose.

No way exists to directly write to a text file from a stored procedure. There are several ways to indirectly output text from a SP. Check the info in the SQL FAQ at Terry Broadbent


"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top