Re: Problems with UTL

From: Fred Stojentin <stojentin_at_orgdv.din.de>
Date: Wed, 16 Jun 1999 13:33:58 GMT
Message-ID: <3767a50e.21816155@news.cis.dfn.de>

On Mon, 14 Jun 1999 12:09:29 GMT, Peter C. <pcugier_at_my-deja.com> wrote:

>We have the following problem using the UTL_FILE package on an AIX
>system running Oracle 7.3.4.
>
>We are able to write a small amount of data to a file by using the
>UTL_FILE.PUT_LINE procedure. But if we try to write a couple of hundred
>records to the file we get an WRITE_ERROR exception.
>
>Did anybody experience the same problem or does someone know if the
>size of files created with UTL_FILE is limmited.
>
>Thanks
>
>Peter
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

Hello Peter,

on hp ux 10.20 with oracle 7.1.4, 7.2.3 and all 7.3.x we've had no problems to write large files (>100 MB) with utl_file. Maybe utl_file.fflush(fHandle) will work - the implementation of utl_file is really bad.

Fred Stojentin Received on Wed Jun 16 1999 - 08:33:58 CDT

Re: Problems with UTL_FILE Package