Maximum limit of open files using the UTL_FILE.FOPEN utility
812115Mar 8 2011 — edited Mar 13 2011Is the number of open files set at 50 ? Is there a way to configure so that I can open more files than 50 ? The way the system works is that it opens all the files that will be used throughout processing, and then depending on the kind of transaction record that is read, it will then write to the appropriate file. It appears that I have hit a limit when I added new set of files, and I am getting Invalid Operation when trying to open more files than 50. It might not be efficient, if I were to open and close files everytime I need to write a record.
Thank you.