Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Read error using UTL_FILE

Read error using UTL_FILE

From: Giridhar <gkodakalla_at_gmail.com>
Date: 5 Jan 2006 05:46:30 -0800
Message-ID: <1136468790.128064.162420@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. Received on Thu Jan 05 2006 - 07:46:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US