Best is your suggestion of calling get_path on the folder before doing the folder chunk query then concatenating the folder name and file name in the big select rather than call get_path.
Yes, that is by far the best solution.
I'm implementing this right now and will post when I'm done. It's great that you're willing to test the changes, Don. I don't currently have an oracle install at hand but hopefully you do ...
Thanks Dave, your thinking makes this easy.
/Ola
