Best way to deal with hard coded variables in a package
637862May 6 2008 — edited May 6 2008Hello all,
This is probably a simple question and I am pretty sure there is a quick answer for this.
My package is reading data from a file in a specified directory and then writing an output file to the same directory with a different file name.
I use utl_file function to open files. As far as the file name and directory goes, I have the values stored in a table. The batch PLSQL program will probably read about 50,000 rows from an input file, perform a ton of operations and then write to the output file.
Is that the best way to do it or would you suggest some other way to do it.
Thanks
Saugato