1 Reply Latest reply: Apr 1, 2013 6:05 PM by rp0428 RSS

    UTL_FILE and 724,000 byte file

      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?