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" <Rajendra.Jamadagni_at_espn.com> 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: 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).
Received on Thu Aug 22 2002 - 09:58:25 CDT