Re: Read error using UTL_FILE

"Giridhar" <gkodakalla_at_gmail.com> wrote in message news:1136468790.128064.162420_at_g44g2000cwa.googlegroups.com...
> Hi,
> we use UTL_FILE to read files in our PL/SQL Program.
> Today we got an exceptional file, which is greater than 2 GB.
> our program failed with the error as:
>
> SQLCODE <-29284> SQLERRM <ORA-29284: file read error>
>
> Is there any restriction on the file size we can use with UTL_FILE?
> In case if there is any restriction, is there any way to overcome this
> restriction?
>
> Thanks,
> Giridhar Kodakalla.
>

Does your filesystem support files greater than 2 GB ? What OS are you using ? Received on Sat Jan 07 2006 - 12:19:14 CST