Hi,
I have to display image using html in pl/sql dynamic content. Images are stored in database table T_PHOTO ( ID, Blob, filename) . I have created table to display few information of the employees along with the image so I can display image side by side. I am not getting how to give src path in below code for image:
htp.p('<table style="font-size:16px; width:90%">');
htp.p('<tr><td>Employee ID </td>''<td> '||ID||'</td>');
htp.p('<td rowspan="6"><img src="???????"/> </td></tr>'); ----- What path i have to use to get image from the database table T_PHOTO where employee_id = Photo_id
htp.p('<tr><td>Employee Name </td><td> '||NAME||'</td></tr>');
htp.p('<tr><td>Date of Birth </td><td> '||DOB||'</td></tr>');
htp.p('<tr><td>Employee Age </td><td> '||AGE||'</td></tr>');
htp.p('<tr><td>Gender </td><td> '||GEN||'</td></tr>');
htp.p('<tr><td>PF Account </td><td> '||PF||'</td></tr>');
htp.p('</table>');
htp.p('<td rowspan="6"><img src="#APP_IMAGES#images_trinity1.jpg"/> </td></tr>');