title: Linking to a File in Oracle ApEx
body: <p>I'm trying to create a report in Oracle ApEx that displays a list of files, and allows you to download them.</p>
  
  <p>The files are being created by an external application and I have full control over where they are placed. Just now I am creating them in a subfolder of the ApEx images directory (C:\oracle\product\11.2.0\dbhome_1\apex\images). However, if I try to link to here, I just get a blank page - I've tried the <code>#WORKSPACE_IMAGES#</code> and <code>#IMAGE_PREFIX#</code> values as the link URL but it doesn't work.</p>
  
  <p>There doesn't seem to be any way to automatically add a file to ApEx's <code>flows_files.wwv_flow_file_objects$</code> table other than having an ApEx page do it (or upload it as a static file using the ApEx workspace). One thing I think might be possible is to manually insert a record into the table, but with the various IDs it requires this could be a minefield.</p>
  
  <p>Has anyone else came across this problem? Linking to a file on any other webserver would be elementary, especially if it is placed under the document root.</p>