This discussion is archived
2 Replies Latest reply: Nov 18, 2012 11:35 PM by Mindmap RSS

Download Formatting Mask for BLOB column

Sombit Newbie
Currently Being Moderated
Hi All,

IR Query : select "ROWID","FILE_NAME",dbms_lob.getlength("DATA_FILE") "DATA_FILE",
"DOC_SIZE",PROPOSAL_OWNER
from "#OWNER#"."APXTER_IMP_HDR"

I am using BLOB Download Format Mask on FILE_NAME column

using the following FORMATTING

DOWNLOAD:APXTER_IMP_HDR:DATA_FILE:ROWID::::::attachment:Download

After applying the changes, I counter the error

The number of display columns in the report reached the limit. Please click Select Columns under Actions menu to minimize the report display column list.

Thanks,
Sombit
  • 1. Re: Download Formatting Mask for BLOB column
    Sombit Newbie
    Currently Being Moderated
    Hi All,

    Any pointers please

    Thanks,
    Sombit
  • 2. Re: Download Formatting Mask for BLOB column
    Mindmap Pro
    Currently Being Moderated
    Hello,

    Here you can find a tutorial about blob:
    http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/apex/r31/apex31nf/apex31blob.htm

    I have a demo here - it shows how to display an image in case the file is image. Otherwise, it displays download link:

    http://apex.oracle.com/pls/apex/f?p=63066:1
    workspace: somefeto
    user: test
    pwd: test
    Application 63066

    Also, there is a packaged application : Sample File Upload and Download that shows you, how to do it.....
    you can find it on your workspace.. or here if you wish:
    http://apex.oracle.com/pls/apex/f?p=10540:3:15582111009947::NO
    workspace: somefeto
    user: test
    pwd: test

    Regards,
    Fateh
    --------------
    If you believe that my answer was helpful to you or correct, then please mark the answer as helpful or correct ...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points