Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g7MDoM324311 for ; Thu, 22 Aug 2002 09:50:22 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id GAA98418; Thu, 22 Aug 2002 06:47:40 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004BC79B; Thu, 22 Aug 2002 05:58:32 -0800 Message-ID: Date: Thu, 22 Aug 2002 05:58:32 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Adams, Matthew (GEA, MABG, 088130)" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Adams, Matthew (GEA, MABG, 088130)" Subject: RE: utl_file_dir vs create directory Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPartTM-000-f432c1cd-1fac-4605-80fd-9912ec3625b9" ------=_NextPartTM-000-f432c1cd-1fac-4605-80fd-9912ec3625b9 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C249DA.8635B4C0" ------_=_NextPart_001_01C249DA.8635B4C0 Content-Type: text/plain; charset="iso-8859-1" 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@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@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@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). ------_=_NextPart_001_01C249DA.8635B4C0 Content-Type: text/html; charset="iso-8859-1" RE: utl_file_dir vs create directory

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@appl.ge.com
My computer beat me at chess, but I won
when it came to kick boxing.

-----Original Message-----
From: Rachel Carmichael [mailto:wisernet100@yahoo.com]
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: wisernet100@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@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).

------_=_NextPart_001_01C249DA.8635B4C0-- ------=_NextPartTM-000-f432c1cd-1fac-4605-80fd-9912ec3625b9-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adams, Matthew (GEA, MABG, 088130) INET: MATT.ADAMS@APPL.GE.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@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).