As salamualikum (islamic greetings), brothers and sisters. :)
Today, i discuss an important issue, many of oracle developer spend hours and hours to make a reports to show image from file system, which is much complex.
From Now on, it will be easy and remain easy. :)
Follow the bellow steps.
- Take a Formula column
- Data Type Char
- Length 500
- Set READ FROM FILE property to YES
- Set File Format to Image
- Make the Image stored folder as Shared Folder
function CF_IMAGEFormula return Char is
tiff_image_dir VARCHAR2(80) :='<PC_NAME>/emp_picture/'; --// Folder name should be shared for shared link.
out_file :=Text_IO.Fopen(tiff_image_dir||:EMP_CODE||'.jpg', 'r'); -- r is read only AND EMP_CODE is the name of image.
filename := tiff_image_dir||:EMP_CODE||'.jpg';
when no_data_found then
when others then
if sqlcode=-302000 then
You are Done :)
Pray for me to Almighty Allah (swt) to keep it up and for my hereafter.