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: utl_file_dir vs create directory

Re: utl_file_dir vs create directory

From: Don <dondealy_at_teleport.com>
Date: Sat, 24 Aug 2002 12:53:18 -0800
Message-ID: <F001.004BF24C.20020824125318@fatcity.com>

See Metalink Note:196939.1

At 08/22/2002 05:58 am, you wrote:
>Okay, I'll admit I know nothing about the create directory command and
>am off to read the fine manuals as soon as I hit send on this....
>
>my developer sent me an email saying "do you know of this new feature
>create_directory? it is recommended to use create_directory instead of
>utl_file_dir"
>
>First, she's not in, I can't ask her WHO recommended it. But I will.
>Second, I think she meant create directory, without the underscore.
>
>Basically what we are doing is reading an orders table and generating a
>flat file to be shipped to the fulfillment center. This will be done
>via a PL/SQL procedure which will be called at regularly scheduled
>times.
>
>Why would I want/need to use create directory instead of utl_file? The
>database will go live in 9.2.0.1
>
>Any advice is welcome!
>
>Rachel
>
>
>__________________________________________________
>Do You Yahoo!?
>HotJobs - Search Thousands of New Jobs
>http://www.hotjobs.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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.com
-- 
Author: Don
  INET: dondealy_at_teleport.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Sat Aug 24 2002 - 15:53:18 CDT

Original text of this message

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