Hi,
I developed a public page where I want to list some articles from a view. It has to be a classic report because of the template I want to use later.
The query is done with the typical HTML-structure:
select "ARTI_ID",
"ARTI_BESCHREIBUNG",
"ARTI_PREIS",
"ARTI_PORTO",
decode(nvl(dbms_lob.getlength("ARTI_BILD" ),0),0,null,
'<img style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '||
'src="'||apex_util.get_blob_file_src('P3_ARTI_BILD',"ARTI_ID")||'" height="75" width="75" alt="Bild" title="Bild" />') "ARTI_BILD"
from "#OWNER#"."TRAN_ALLE_ARTIKEL_V"
WHERE "ARTI_IST_GUELTIG"="J"
I used this query in an interactive report without problems on a page with authentication. Of course I edited the page ID in the element P3_ARTI_BILD
Now, how can i manage that this works?
The application runs on apex.oracle.com on APEX 5.
Greetings
Steven