Re: reading unix files into oracle db

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 26 Feb 2004 02:37:13 GMT
Message-ID: <tZc%b.17270$BD7.3848@newssvr29.news.prodigy.com>

arjan wrote:
> Hi
>
> I have a prob reading files from the server into an oracle db using
> UTL_File.
>
> When I manually create a file on the server using vi, it reads in
> nicely.
>
> However, when I try to do the same thing with a unix file that's
> ftp-ed from a windows client to the server, oracle gives me 'invalid
> operation'.
>
> ??

This is probably an FTP issue.

Using FTP, transfer the file from Windows to Unix using the "ASCII" mode (default). This will translate the line endings from CR/LF to a single "newline" which is standard under Unix.

Using "binary" aka IMAGE mode will not work as expected for a flat text file between Unix and Windows.

--Mark Bole Received on Wed Feb 25 2004 - 20:37:13 CST