Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Apex Report with BLOB content (APEX 4.0)
Apex Report with BLOB content [message #513321] Sun, 26 June 2011 19:15
komasi75
Messages: 3
Registered: May 2011
Location: new zealand
Junior Member
I'm trying to display a report that sits ontop of a table with a BLOB column.

The page I display the report on, also has an "file browse" item that allows the user to upload a record to this table. The following code is the source of a "process" that is triggered by the user hitting the UPLOAD button. (Takes a copy of wwv_flow_files view and adds it to my table, then deletes the record from wwv_flow_files);

begin

insert into SPM_REQUEST
(id, file_name, redirection_number, mimetype, load_date, document)
select SPM_REQUEST_SEQ.nextval,
filename,
:P1_REDIRECT_NO,
mime_type,
created_on,
blob_content
from wwv_flow_files
where name = :P1_NAME;

delete wwv_flow_files where name = :P1_NAME;

end;

This adds the record okay and displays the record in my report (I've formatted the BLOB column so it appears as a link) ok, but when I click on the link I get redirected to "webpage cannot be found" page.

This is confusing as there are records already in this table that have blob content (PDFs) that display in my report and when I click on their links, it opens the PDF document correctly??
Previous Topic: How to Create an Application with no template and custom made CSS
Next Topic: Updatable views
Goto Forum:
  


Current Time: Fri Mar 29 02:23:10 CDT 2024