Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Text file from store procedure
You can spool output to the location of your choice in sqlplus. Forms
allows you to use a utl_file like procedure called 'text_io' I believe. In
6i the output is written to the client machine, in 9i the results are
written to the app server.
Why don't you want to use utl_file? It is designed to create and write text files from PL/SQL blocks.
-----Original Message-----
Hamid Alavi
Sent: Wednesday, August 20, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
List of guru,
Is any body know how can I create a text file from store procedure without using utl_file , I want to create & write a text file from result of a select statement and write the result as a text file in a define directory. Thanks for your help.
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: hamid.alavi_at_quovadx.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Aug 20 2003 - 19:44:25 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: smcclure_at_usscript.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |