Re: Alternatives to using utl_file

  • From: Joerg Jost <joerg.jost@xxxxxxxxxxxx>
  • To: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 16 Dec 2008 13:31:26 +0100

Am Dienstag, den 16.12.2008, 12:25 +0000 schrieb John Dunn:
> Apart from re-writing pl/sql to java, what are the alternatives to
> utl_file that I can use in PL/SQL to read and write files?
>  
> Oracle version is 10.2

Hi,

try using directories.

Very handy, no Database restart and easy to use.

See
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5007.htm#SQLRF01207

vor details.

bye

Jörg Jost


-- 
You can have it: Fast, Right or Cheap, pick 2 of the 3.
Fast + Right is Expensive
Fast + Cheap will be incorrect.
Right + Cheap will take a while. 
--
//www.freelists.org/webpage/oracle-l


Other related posts: