| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: utl_file_dir vs create directory
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)" <MATT.ADAMS_at_APPL.GE.COM>
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 - 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: 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:26 CDT
 |
 |