5 Replies Latest reply: Mar 6, 2013 11:41 PM by yxes2013 RSS

    Display image in report APEX 4.2

    Maxime Carrier
      Hi all,

      I've tried several tutorials on the web to display an image in a report from a BLOB data type, but I still can't display them in a report. I know I uploaded my BLOB correctly because I'm able to use the 'display image' item to display it, but I can't put it in the report.

      When I put it in BLOB format, I have this error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error

      When it stays in the default format, it is written: *[Unsupported data type]*

      Does anyone have a clue? Is it because I used APEX 4.2?

      Thanks :)
        • 1. Re: Display image in report APEX 4.2
          KeithMalay
          Maxime,

          It's going to be hard to tell what's going on without more detail. Any chance you can post an example of your problem on apex.oracle.com ?


          Keith Malay
          Blackhawk Enterprise Inc
          • 2. Re: Display image in report APEX 4.2
            fac586
            Maxime Carrier wrote:

            I've tried several tutorials on the web to display an image in a report from a BLOB data type, but I still can't display them in a report. I know I uploaded my BLOB correctly because I'm able to use the 'display image' item to display it, but I can't put it in the report.

            When I put it in BLOB format, I have this error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
            What is "BLOB format"?
            When it stays in the default format, it is written: *[Unsupported data type]*
            Please review the documentation carefully: About BLOB Support in Forms and Reports. In particular, note:
            To facilitate the inclusion of a download link in a report, the report includes the selection of the length of the BLOB (for example, <tt>dbms_lob.getlength(RESUME)</tt>).
            Ensure your report query includes such a selection of the image BLOB's length, not the BLOB itself, and that the format mask of this column is as described in the "Displaying the BLOB" section.
            • 3. Re: Display image in report APEX 4.2
              Maxime Carrier
              fac586 wrote:
              Maxime Carrier wrote:

              I've tried several tutorials on the web to display an image in a report from a BLOB data type, but I still can't display them in a report. I know I uploaded my BLOB correctly because I'm able to use the 'display image' item to display it, but I can't put it in the report.

              When I put it in BLOB format, I have this error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
              What is "BLOB format"?
              It is the column attribute 'Number / Date Format' for the specific column.

              >
              When it stays in the default format, it is written: *[Unsupported data type]*
              Please review the documentation carefully: About BLOB Support in Forms and Reports. In particular, note:
              To facilitate the inclusion of a download link in a report, the report includes the selection of the length of the BLOB (for example, <tt>dbms_lob.getlength(RESUME)</tt>).
              Ensure your report query includes such a selection of the image BLOB's length, not the BLOB itself, and that the format mask of this column is as described in the "Displaying the BLOB" section.
              I'm using everything it is required in this documentation, I use a File Browser to store the image, the length, the mime type, the filename, the last update date. The importation works perfectly, I'm also able to display the imported image in the 'Display image' page item in APEX, but I can't display it in the form.

              This is how it looks:

              http://postimage.org/image/4mvtld02j/

              and

              http://postimage.org/image/s0wghalfh/

              Thanks for your quick answers :)
              • 4. Re: Display image in report APEX 4.2
                Maxime Carrier
                Hi all,

                using dbms_lob.getlength("BLOB_IMAGE") as "BLOB_IMAGE" in my select statement, I am able to see the image perfectly!

                Thanks all for your help!
                • 5. Re: Display image in report APEX 4.2
                  yxes2013
                  Hello dear,

                  I have also similar issue :(
                  Can you share me the procedure how to do what you have done please....

                  Thanks a lot,