2 Replies Latest reply: Nov 19, 2012 1:35 AM by Mindmap RSS

    Download Formatting Mask for BLOB column

    Sombit
      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
          Hi All,

          Any pointers please

          Thanks,
          Sombit
          • 2. Re: Download Formatting Mask for BLOB column
            Mindmap
            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 ...