Oracle Application Express (MOSC)

MOSC Banner

Can not process blob file in interactive report

I created an interactive report that includes qry'ing a blob file [which is a scanned document], and i want to give the user the option to download or view the scanned document[attachment to invoice, e.g.]

the query is:

select distinct

I.invoice_id,

I.invoice_num,

vendor_name,

invoice_amount,

inv_status,

invoice_received_date,

invoice_date,

sys.dbms_lob.getlength(file_data) download_image,

sys.dbms_lob.getlength(file_data) view_image

from

XXNEO_AP_INVOICES_MV@APEX_EBS_DBLINK I,

XXNEO_AP_INVC_ATTACH_APEX_MV A

WHERE 

I.INVOICE_ID = NVL(:P103_INVOICE_ID, I.INVOICE_ID)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center