Good morning all,

I have been on APEX for a short time and I am having a problem displaying my image in the 'Articles' section of my application (which will be a website).

I have a form to create an article. Once the article is created we can view it and consult it on this page:

https://apex.oracle.com/pls/apex/f?p=60168:11:731885896275397::NO:::

My SQL Request :

select ID,
TITRE "CARD_TITLE",
AUTEUR "CARD_SUBTITLE",
DESCRIPTION "CARD_SUBTEXT",
DECODE(TO_CHAR(nvl(dbms_lob.getlength(PHOTO),0)), '0', null,
'<img alt="'||apex_escape.html_attribute(PHOTO_FILENAME)||'"title="'||apex_escape.html_attribute(PHOTO_FILENAME)
||'" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '
||'src="'||apex_util.get_blob_file_src('P13_PHOTO', ID)||'" height="150" width="200" />')"CARD_TEXT"
from ARTICLES

I already asked this question on StackOverflow but I didn't get an answer:

https://stackoverflow.com/questions/59487630/image-does-not-appear-apex-oracle/59491863?noredirect=1#comment105180120_59491863

The concern is that the data on the pages is dynamic so it may pose a problem regarding the SEO of the website.

Do you know how I can overcome my two questions?

Thanks in advance, nice day.

Valentin