Oracle-L: RE: utl_file_dir vs create directory

From: Adams, Matthew (GEA, MABG, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Thu, 22 Aug 2002 05:58:32 -0800
Message-ID: <F001.004BC79B.20020822055832@fatcity.com>

I believe that the 'create directory' command is only appropriate when dealing with BFILEs.

It's not exactly a substitute for the UTL_FILE package and UTL_FILE_DIR parameter.

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com My computer beat me at chess, but I won
when it came to kick boxing.

-----Original Message-----
Sent: Thursday, August 22, 2002 8:59 AM
To: Multiple recipients of list ORACLE-L

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: Adams, Matthew (GEA, MABG, 088130) INET: MATT.ADAMS_at_APPL.GE.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------