that's what I thought, but the docs would lead you to believe it is the preferred substitute in all cases...
I was always under the impression that BFILEs are read-only. If this is wrong, then we can and should probably use the 'create directory' and BFILE. If this is right, then a BFILE is useless to me in this circumstance Rachel --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]> wrote: > 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----- > 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: [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). > __________________________________________________ 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).
