REP-0606 unable to read linked file check link file format in oracle reports

Question

I am reading a image file and showing it in Oracle reports 6i. Below coding is for your reference.

function cf_imageFormula return Char is

out_file Text_IO.File_Type; 
image_1 varchar2(2000);`enter code here`

begin
  select   'Q:\sy\img\'||:pyempcde||'.' || 'jpg'  into image_1
from dual;


out_file :=Text_IO.Fopen('Q:\sy\img\'||:pyempcde||'.' || 'jpg', 'r'); 

return ('Q:\sy\img\'||:pyempcde||'.' || 'jpg');

exception 
when no_data_found then 
return('Q:\sy\img\no_image.jpg'); 
when others then 
return('Q:\sy\img\no_image.jpg');
end;

The image also showing successfully in report for the first record, from second record the subjected error is showing. Please help me with solution..

Answer 1

As far as I can tell, image size might be the issue. Reports isn't capable of displaying (too) large images (in size, [KB], not centimeters). If that's the case, there's nothing much you can do about it, unless you resize images and make them much smaller (regarding what you've said - it displays only one image ... that's close to nothing).

Just wondering: how large are those images? How many of them are you supposed to display in the report?