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 - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.
-----Original Message-----
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 22, 2002 8:59 AM
To: Multiple recipients of list ORACLE-L
Subject: utl_file_dir vs create directory
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
