链接到Oracle ApEx中的文件

本文介绍了链接到Oracle ApEx中的文件的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试在Oracle ApEx中创建一个报告，该报告显示文件列表，并允许您下载它们.

I'm trying to create a report in Oracle ApEx that displays a list of files, and allows you to download them.

文件是由外部应用程序创建的，我可以完全控制它们的放置位置.刚才，我在ApEx映像目录的子文件夹(C:\ oracle \ product \ 11.2.0 \ dbhome_1 \ apex \ images)中创建它们.但是，如果我尝试链接到这里，我只会得到一个空白页-我尝试使用#WORKSPACE_IMAGES#和#IMAGE_PREFIX#值作为链接URL，但是它不起作用.

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.

似乎没有任何其他方法可以自动将文件添加到ApEx的flows_files.wwv_flow_file_objects$表中，除非有一个ApEx页面(或使用ApEx工作区将其上传为静态文件).我认为可能的一件事是手动在表中插入一条记录，但是由于需要使用各种ID，因此这可能是一个雷区.

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.

还有其他人遇到过这个问题吗?链接到任何其他Web服务器上的文件都是基本的，尤其是如果该文件位于文档根目录下.

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.

推荐答案

只是提供对此问题的解答，以防万一有人偶然发现此问题-我设法通过将文件作为BLOB值存储在数据库中来解决该问题.然后，您可以按照以下说明设置ApEx以提供这些文件: download.oracle/docs/cd/E14373_01/appdev.32/e13363/up_dn_files.htm#CIHHEHCJ

Just to provide an answer to this in case anyone stumbles upon this question - I managed to resolve it by storing the files in the database as BLOB values. You can then set up ApEx to serve up these files by following the instructions here: download.oracle/docs/cd/E14373_01/appdev.32/e13363/up_dn_files.htm#CIHHEHCJ