search

vincentmorneau / material-apex

A Material Design Theme for Oracle APEX
https://apex.oracle.com/pls/apex/f?p=12192
MIT License
189 stars 51 forks source link

BLOB column in a table #376

Closed malekammous closed 4 years ago

malekammous commented 4 years ago

Hello, I will be grateful if you find a solution to my problem. I would like to use a blob image from my database for these cards. I tried with this code but it gives nothing:

select dbms_lob.getlength(IMG_PMV) as image ,'Click here' title ,'I am a very simple card. I am good at containing small bits of information. I am convenient because I require little markup to use effectively.' content ,'This is a link' btn_label_1 ,' ' btn_label_2 from RP_PMV where COD_TYP_PMV=30 union select
dbms_lob.getlength(IMG_PMV) as image ,'Click here' title ,'I am a very simple card. I am good at containing small bits of information. I am convenient because I require little markup to use effectively.' content ,'This is a link' btn_label_1 ,' ' btn_label_2 from RP_PMV where COD_TYP_PMV=31

vincentmorneau commented 4 years ago

This is not a Material APEX issue, but here: https://docs.oracle.com/en/database/oracle/application-express/19.2/aeapi/GET_BLOB_FILE_SRC-Function.html#GUID-21F2D33A-A616-48B5-BAF5-A85C0EDC998F