Problem when importing large files into text fields using TEXT_IO

Hi,

I'm importing text files into text item field. The code I'm running is the following:

  ftype := TEXT_IO.FOPEN(fname,'r');
  TEXT_IO.GET_LINE(ftype,ftext);
  :text_value := ftext;
  ftext := '';
  LOOP
    text_io.get_line(ftype,ftext);
    :text_value := :text_value||chr(10)||ftext;     ftext := '';
  END LOOP; EXCEPTION
  when no_data_found then -- close the file when data end     TEXT_IO.FCLOSE(ftype);

According to documentations, text item have no size limit. However, when I'm importing large files (more than ~500 lines), I get value error exception - the data is too big. I consulted Oracle support, and they claimed that though I'm not using varchar variable (that limits to 32,000 chars), the loop above is implemented by using one, and since it's larger then 32,000 chars, it failed. They recomended using user exit as a solution to this problem. My questions are:
1) Does anybody had this problem? Is Oracle's explenation is the right

   one?
2) Since I'm not familiar with user exit, is this the best solution for

   such a problem? Any idea how should I do it?

Any help will be appreciated,
Thanks,
Maoz Received on Mon Sep 29 1997 - 00:00:00 CEST