Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Read error using UTL_FILE
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.
Received on Thu Jan 05 2006 - 07:46:30 CST
![]() |
![]() |