Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Text file from store procedure

RE: Text file from store procedure

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Wed, 20 Aug 2003 18:49:37 -0800
Message-ID: <F001.005CBD69.20030820184937@fatcity.com>


Hamid,

Hit www.hotsos.com and find Sparky. The trcfiled part of the distribution is a well-documented Perl program that is capable of doing utl_file's job between 100x and 1,000x faster than utl_file does it.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:

- Hotsos Clinic 101 in Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-----Original Message-----

Steve McClure
Sent: Wednesday, August 20, 2003 7:44 PM To: Multiple recipients of list ORACLE-L

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-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).

--

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Cary Millsap
  INET: cary.millsap_at_hotsos.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). Received on Wed Aug 20 2003 - 21:49:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US