This discussion is archived
1 Reply Latest reply: Apr 1, 2013 3:48 PM by chuckers RSS

UTL_FILE and 724,000 byte file

chuckers Newbie
Currently Being Moderated
If I'm trying to read in a 724,000 byte file with '~' delimiters with UTL_FILE, does that mean that I need to read it in as a CLOB? While I know that an external table definition is an option, what I really need to do is just read in the first 200 characters, so the external table seems like overkill.

I was trying to push UTL_FILE in the direction of using GET_LINE( ) to read in 200 bytes, kind of like getting it to work like a SUBSTR, but on a file's contents. Could someone give me some pointers if it's possible?

Thanks,
--=Chuck

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points