16.4.7.2 Configuring Reference Image Page Item

Use a BLOB-backed form item to let GET_BLOB_FILE_SRC infer the file metadata for an image URL.

Recall the expression used in the query to generate the image URL:

select 
       ⋱
         apex_util.get_blob_file_src('P12_IMAGE', ID)
       ⋰
  from eba_demo_emp_breakroom_photo_v

ID is the primary key column in the employee break room photos view, and P12_IMAGE names a form page item whose source is the image BLOB. GET_BLOB_FILE_SRC infers the column names for the file BLOB, MIME Type, and Last Updated date from this page item. It gets the table name from the source of the item's related Form region.

The P12_IMAGE item does not need to be visible on the page. As shown below, it can reside in the Dialogs, Drawers, and Popups slot on the page or be visually hidden by applying the u‑hidden CSS class.

Figure 16-31 Form Image Item GET_BLOB_FILE_SRC References for BLOB Metadata

Description of "Figure 16-31 Form Image Item GET_BLOB_FILE_SRC References for BLOB Metadata"