RE: Alternatives to using utl_file

From: <TESTAJ3_at_nationwide.com>
Date: Tue, 16 Dec 2008 09:07:27 -0500
Message-ID: <OF060B20B4.8CAB8B8F-ON85257521.004D71CC-85257521.004D60A6@lnotes-gw.ent.nwie.net>

sorry i'm coming in on this thread late, so if thats already been discussed or is not feasible, feel free to hit delete now. :)

if you're doing things dynamically, use the create directory command and then you dont' have to mess with utl_file_dir. You can create the directory on the fly, use it and then drop it if need be.

joe

---

Joe Testa, Oracle Certified Professional Senior Consultant
Data Engineering and Administration
Nationwide Investments

(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage? Ask me about "Weekend to Remember"
Dec 12-14, 2008 here in Columbus.

From:
"John Dunn" <JDunn_at_sefas.com>
To:
"Booth.Steve" <Steve.Booth_at_we-energies.com>, <oracle-l_at_freelists.org> Date:
12/16/2008 09:04 AM
Subject:
RE: Alternatives to using utl_file
Sent by:
oracle-l-bounce_at_freelists.org

OK, thanks  

The biggest issue I have with utl_file is needing to define utl_file_dir=  

Since the directories we need to access are not known till run time we have to specify utl_file_dir=*, which is a security nightmare.      

John

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 16 2008 - 08:07:27 CST