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