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

Home -> Community -> Mailing Lists -> Oracle-L -> utl_file_dir vs create directory

utl_file_dir vs create directory

From: Rachel Carmichael <wisernet100_at_YAHOO.COM>
Date: Thu, 22 Aug 2002 04:58:41 -0800
Message-ID: <F001.004BC603.20020822045841@fatcity.com>


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). Received on Thu Aug 22 2002 - 07:58:41 CDT

Original text of this message

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