I am writing a program which will run on multiple files in a directory. The program is working good for 1 file, but doesn't go in a loop to read other files. I am reading file names from a table into a cursor.
Problem is that after reading first file till the end, it will exit out of the loop instead of going back to fetch another file. This is happening because after reading first file till the end there is no condition to verify end of file and return back to the loop.
The files may have multiple blank lines in between, so the concept of looking for a couple of new line characters chr(30) at the end won't work for me.