16.4 Displaying BLOB Column Images

Display images from a URL or BLOB column in common APEX regions, with a special approach for Interactive Grid.

All regions can display images using a URL, but many can display images directly from a BLOB column including: Form, Cards, Classic Report, Interactive Report, Template Component, and Search. Showing a graphic in an Interactive Grid requires an <img> HTML tag whose src attribute references the URL of the graphic to display.

• Showing BLOB Column Images on Cards
  Configure a Cards region to display uploaded photos from a BLOB column with captions and preview links.
• Previewing Image in a Form Region
  To preview an image from a BLOB image column, use a Form region based on the table or view that includes it, or use a SQL query that selects it.
• Displaying BLOB Images in Classic Reports
  In a Classic Report region, include the size of the BLOB in your query instead of the BLOB column itself.
• Using BLOB Images in Interactive Reports
  In an Interactive Report region, include the size of the BLOB in your query instead of the BLOB column itself.
• Including BLOB Images in Content Row
  In a Content Row Template Component region, choose a table or view that includes the BLOB image column.
• Viewing BLOB Images in Search Results
  When creating a Search page, base your related Search Configuration on table or view including the BLOB image column.
• Showing BLOB Images in Interactive Grid
  An Interactive Grid has no native Display Image column type. To show an image in a row, use an HTML <img> tag with a src URL the browser can fetch and render inline.
• Using BLOB Column Image URLs Anywhere
  While the Interactive Grid requires it, use your preferred image URL generation approach anywhere that supports an image URL.