yes I saw the docs..... but that doesn't tell me that I can CREATE A FILE which is what we want to do. Since this is a new application and database, I can bounce the instance all I want, no one is using it except me and the programmers yet....
--- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > Rachel, > > it is recommended that you use "create directory" rather than > utl_file_dir. > http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920 > /a96590/whatsnew.htm#970251 just scroll down a bit. I think create > directory > will let you perform the function of utl_file_dir but dynamically. > For > changing utl_file_dir you required to bounce the instance, but not in > this > case. I think this is why ... > > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of > ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion is an art! > > > -----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 > > *********************************************************************This > e-mail message is confidential, intended only for the named > recipient(s) above and may contain information that is privileged, > attorney work product or exempt from disclosure under applicable law. > If you have received this message in error, or are not the named > recipient(s), please immediately notify corporate MIS at (860) > 766-2000 and delete this e-mail message from your computer, Thank > you.*********************************************************************2 > __________________________________________________ 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).
