I'm trying to create a report in Oracle ApEx that displays a list of files, and allows you to download them.
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 #WORKSPACE_IMAGES#
and #IMAGE_PREFIX#
values as the link URL but it doesn't work.
There doesn't seem to be any way to automatically add a file to ApEx's flows_files.wwv_flow_file_objects$
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.
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.