Once again with my doubts here.
Right now I am using this sql statement
p_blob(i):= package_email.read_file('shared_files','booking_dealer.xls'); file_name(5):='booking_dealer.xls';
As of now, I have changed the way the file is generated. There will be many files for every dealer who meets certain criteria.
So, the files will look like this: booking_dealer_42446.xls booking_dealer_78944.xls and so on
How can I use a loop to read those files, may be using wild card? or arrays?
Or is there totally another method? How can I implement this?
Please guide me.
Thanks