I use;
" select
p.apellido || ', ' || p.nombre nombre_profesor,
p.titulacion Titulo,
p.bio Experiencia,
d.nombre Departamento,
p.prof_id Profesor_ID,
APEX_UTIL.PREPARE_URL(
p_url =>'f?p='||:app_id||':8:'||:app_session||'::::P8_PROF_ID:'||p.prof_id
,p_url_charset => 'AL32UTF8'
)
icon_link,
decode(nvl(dbms_lob.getlength(p.foto),0),0,null,
'<img style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '||'src="'||
apex_util.get_blob_file_src('P8_FOTO',p.prof_id)|| '" height="75" width="75" alt="Foto Profesor" title="Foto Profesor" />') detail_img,
decode(nvl(dbms_lob.getlength(p.foto),0),0,null, apex_util.get_blob_file_src('P8_FOTO',p.prof_id)) detail_img_no_style
from edu_profesores p, edu_departamentos d
where p.depto_id = d.depto_id
order by 1 "
As a Sql Query in a Apex Report Page.
The result of the query, shows correctly a link to go to detail of row. Example "f?p=117:8:3049834995935::::P8_PROF_ID:3&cs=3NfnA_QIWazPZcpk6-3q2VzrUH_Y".
Then I enable the "Icon View" option, and as a "Link Column" I use the icon_link column of the report query, and when I click on a record of the icon view of the report; the link is shown as follows: f?p=117:8:3049834995935::::P8_PROF_ID:3&cs=3NfnA_QIWazPZcpk6-3q2VzrUH_Y
Thank you for your answers.