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

Home -> Community -> Mailing Lists -> Oracle-L -> Reading large files with UTL/FILE

Reading large files with UTL/FILE

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Mon, 22 May 2000 10:56:03 +0200 (MET DST)
Message-Id: <10505.106194@fatcity.com>


following problem:

inside a PL/SQL procedure I need to open file containing text and insert the complete file into an internal CLOB. Because varchar2 is limited to 32767 bytes I can not read the file in one run. On the other side UTF_FILE.GET_LINE() also has some limitations. Because lines can be longer than 32768 bytes what is the recommended way for handling such files ?

AndreasB Received on Mon May 22 2000 - 03:56:03 CDT

Original text of this message

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