Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ITEM DISPLAY_IMAGE with APEX 20.1

RémiAug 4 2020 — edited Aug 5 2020

Hi evry one

I'm trying the new environement apex 20.1.

I have a problem with the item DISPLAY_IMAGE.

I use Based on Blob column returned by SQL statement

IF i do SQL statement :

  select d.DOC_BLOB

    from DOCUMENT d

  where d.ZTDOC_CDA = 'PHOTO_PROFIL!'

      and d.JR_CDN = 1;

That work very well

But if i try to do that :

select d.DOC_BLOB

from GAGENCY.DOCUMENT d

where d.ZTDOC_CDA = 'PHOTO_PROFIL!'

   and d.JR_CDN = :P21_JR_CDN;

It's not working.

P21_JR_CDN is a hidden item in the page 21 and is not null

it's 1 or 41

The display_image is in the page 21 too.

Any idea what can be wrong?

Thanks for your help

This post has been answered by Rémi on Aug 5 2020
Jump to Answer
Comments
Post Details
Added on Aug 4 2020
9 comments
765 views