BLOB Column as URL in Oracle APEX

In this tutorial, you will learn about managing and personalizing the presentation of a BLOB column by employing an HTML image tag. Due to the inability to reference BLOB columns through column substitutions, such as COLUMN NAME, it becomes necessary to acquire the BLOB column value as a URL. Once the URL is obtained, you can structure the image display using an HTML img tag.
Create Table [EBA_DEMO_CARD_EMP]
=============================================
CREATE TABLE "EBA_DEMO_CARD_EMP"
( "EMPNO" NUMBER NOT NULL ENABLE,
"ENAME" VARCHAR2(255),
"JOB" VARCHAR2(255),
"MGR" NUMBER,
"HIREDATE" DATE,
"SAL" NUMBER,
"COMM" NUMBER,
"DEPTNO" NUMBER,
"PROFILE_IMAGE" BLOB,
"MIMETYPE" VARCHAR2(255),
"FILENAME" VARCHAR2(400),
"IMAGE_LAST_UPDATE" DATE,
"TAGS" VARCHAR2(4000),
CONSTRAINT "EBA_DEMO_CARD_EMP_PK" PRIMARY KEY ("EMPNO")
USING INDEX ENABLE
) ;
ALTER TABLE "EBA_DEMO_CARD_EMP" ADD CONSTRAINT "EBA_DEMO_CARD_EMP_DEPT_FK" FOREIGN KEY ("DEPTNO")
REFERENCES "EBA_DEMO_CARD_DEPT" ("DEPTNO") ENABLE;
ALTER TABLE "EBA_DEMO_CARD_EMP" ADD CONSTRAINT "EBA_DEMO_CARD_EMP_MGR_FK" FOREIGN KEY ("MGR")
REFERENCES "EBA_DEMO_CARD_EMP" ("EMPNO") ENABLE;
SQL Query [Please add Greater than angle bracket after every = sign]
=========================================================
select EMPNO,
ENAME,
JOB,
MGR,
HIREDATE,
SAL,
COMM,
DEPTNO,
apex_page.get_url(
p_request = 'APPLICATION_PROCESS=GETIMAGE',
p_clear_cache = 5,
p_items = 'PX_EMPNO',
p_values = EMPNO ) BLOB_URL,
IMAGE_LAST_UPDATE,
TAGS
from EBA_DEMO_CARD_EMP
HTML Expression [Please add angle brackets in Start and Last]
========================================================
img src="&BLOB_URL!ATTR." alt="&ENAME!ATTR." style="width:128px;height:128px;"
PL/SQL Code [Please add Greater than angle bracket after = sign]
======================================================
eba_demo_card_pkg.get_profile_image( p_empno = :PX_EMPNO );
Image Attribution
======================================
www.freepik.com/free-vector/b..." Freepik
www.freepik.com/free-ai-image..." Image By freepik

[@ifenia29]

thax for the tutorials we are following

[@sarimmuavia]

Nice to see new theme 👍

[@TechMining69]

More to come!

[@mundova184]

Hi. All good.

[@TechMining69]

Hello 👋

[@JayVincCur]

Thanks for your contribution. I think you forgot the package source "eba_demo_card_pkg.get_profile_image"