Re: Problems with UTL_FILE Package

Log into the os account from which you run the program that has the pl/sql which invokes utl_file. Enter the command:

ulimit -a

If the "file" limit is not "unlimited" then there is a restriction on the size of the file that the account can create.

Also, try running the program as root. If you can create a larger file running from root then that is a good indication that some limit has been placed on the normal account from which you run the program.

Ken

"Peter C." 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.
Received on Thu Jun 17 1999 - 08:59:19 CDT