7 Replies Latest reply on May 20, 2012 8:51 PM by Rod West

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

    Rod West
      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