BFILENAME definition for many a physical File locations
Hi,
I am looking for some advance.
I understand that I must define an Oracle directory object to import files into a BLOB
E.g. bfilename('MEDIA_DIR', 'modem_comp_ad.gif'));
However, the issue I have is that I have potentially hundreds of possible directories when the files can be loaded from, and I don't want to have to copy the files into a single directory (which is defined as a Directory Object), because there will be many users running this process, and I want to avoid creating directory objects 'on the fly'.
Can anyone suggest a method of importing these files dyamically, if possible, without the need to create an Oracle Directory Object???
Any advice would be greatly received?
Oracle version: 10.2.0.5.
Thank you.
David.