Re: Accessing files copied by UTL_FILE.FCOPY

Mark D Powell wrote:

> I have not used it but if you are on 10g+ look up the
> dbms_file_transfer package which while added to Oracle to support
> moving files into and out of ASM states it can copy from OS directory
> to OS directory.
> provides procedures to copy a binary file within a database or to
> transfer a binary file between databases

It works well but there is one caveat. Oracle dropped it from 11g so it is an orphan usable in only a single version of the database.

I have used UTL_FILE with many different file types and can not think of any issues I have encountered that remind me of the OP's description.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org