Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: utl_file_dir vs create directory
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