Can I use a loop

Posted on 16th Feb 2014 by admin

Hi buddies!

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

Other forums