APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to download a file from a table not in the parsing schema

Rod WestMay 17 2012 — edited May 20 2012

We have a table in another schema which holds files in a blob column. I can create a form on this table and the file upload works fine. The file browse page item has the source as the blob column and storage type "BLOB column specified in Item Source attribute". The download link generated for the page shows a call to apex_util.get_blob_file and the parameters are correct. However, when you click on the link you get a Page Not Found 404 error. Same error in Apex 4.1.1. The plsql error is:

ORA-20544: Invalid table owner
ORA-06512: at "APEX_040000.WWV_FLOW_DML", line 1628
ORA-06512: at "APEX_040000.HTMLDB_UTIL", line 2244
ORA-06512: at line 31

Is there a way to use apex_util.get_blob_file to download a file when the table is in another schema?

Rod West

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2012

Added on May 17 2012

#apex-discussions

7 comments

592 views