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