APEX

Hi,

Under Oracle APEX 24.2.13, there are strange problems. I have an Interactive Report on p. 10 with this select :

select a.id_benevole,
      a.id_projet,
      b.NOM_PROJET, b.OBJECTIFS, b.DATE_DEBUT, b.DATE_FIN, b.STATUT, b.COMMENTAIRES, b.CREE_LE, b.CREE_PAR, b.RESPONSABLE,
dbms_lob.getlength(b."FILE1") as "Fichier du projet"
 from ho_projet_benevole a
 left join ho_projet b
   on a.id_projet = b.id
where a.id_benevole = (select user_id 
                         from ho_users 
                        where upper(trim(user_name)) = upper(trim(:app_user)))
order by b.DATE_DEBUT;

The column b.FILE1 ("Fichier du projet") is defined in the column as “Upload" ("Télécharger un fichier"). The BLOB attributes are defined like that:

I save that. Then the Interactive report display the file length instead of the upload link:

When I edit the report The column Fichier du Projet as changed to “Text”:

I created another page 19 from blank as Classical report with the same select for the IR on p.10. This time I get an error:

erreur d'état : ORA-01403: aucune donnée trouvée ("No data found"). But If I run the select under SQL commands:

select a.id_benevole,
      a.id_projet,
      b.NOM_PROJET, b.OBJECTIFS, b.DATE_DEBUT, b.DATE_FIN, b.STATUT, b.COMMENTAIRES, b.CREE_LE, b.CREE_PAR, b.RESPONSABLE,
dbms_lob.getlength(b."FILE1") as "Fichier du projet"
 from ho_projet_benevole a
 left join ho_projet b
   on a.id_projet = b.id
where a.id_benevole = (select user_id 
                         from ho_users 
                        where upper(trim(user_name)) = upper(trim(:app_user)))
order by b.DATE_DEBUT

I get results:

I don't know why all this happens (column type changes on p.10 and No data found on p. 19).

Best regards.