Reading a OS file with line size greater than 32K
948515Jul 10 2012 — edited Jul 11 2012Hi experts,
I have a PL/SQL function that reads an Windows file generated by a 3rd party product - the product outputs text to a single line. I intend to read the file in 32K chunks, do some string manipulation and copy into a CLOB which I pass back for further processing. It ends up embeded into another CLOB containing WordML and output to a file. The CLOB isn't saved into the database.
I am using UTL_FILE for the work, FOPEN and GET_LINE. This fails, however, for files with more than 32K characters in the line. Is there another way I can read the file?
Obviously I can do some processing on the file outside Oracle to divide it into smaller lines, however this will affect performance.
Regards,
Arun