Any alternative to utl_file.GET_LINE !!??
631752May 19 2008 — edited May 19 2008Hello,
I have written a stored procedure that reads-in a file of some 1,000 lines (each line has 400 characters). Each line is parsed and then updates may be performed on certain tables based on the file data processed.
To my mind the processing was running too slowly, so I timed the various parts of the code. To my surprise, of the full 16.2 seconds to process the entire file, 15.9 sec is spent in the call utl_file.GET_LINE()!!
What can I do to improve the performance? How do I deal with utl_file.GET_LINE...parameters, alternatives etc
Thank you in advance for any tips....