Oracle database not opening files with '#' character in them

Question

For some reason, the files in the database won't open if they have the # character in them...

One thing i noticed was in the file name, the link doesn't have %20 for the space characters after the # sign, but even when i replace the rest of the number characters with the %20 character, the link still doesn't work..

Any ideas why it could be?

---

Added from comments I looked more into the code and it seems like this is what actually opens the files; wpg_docload.download_file(v_filename, false);

Answer 1

wpg_docload.download_file is part of Apex and is used to return files to a browser. But # can have a special meaning in a URL so that might be confusing it.

Have a look in WWV_FLOW_FILES and see what the file name is in there (eg has it been encoded in anyway).