rep-0108 image not found
Hi, I am using oracle 10g reports builder
I am trying to dynamic image for the employees at my company according to thier employee ID, few of the employees do not have a pictures.
I am adding the image using the read from file feature.
When an employee has an image everything work fine, but when there isn't an image it gave me the rep-0108 file not found error.
So I tried to use one of the following solution but without any success
1-using exceptions (exception when no_data_found then return ‘c:\dummy.jpg’)
Where dummy.jpg is a dummy image to be displayed for the employee without an image. I soon discovered the
rep-0108 do not raise no_data_found exception.
2-if var_photo is not null then return var_photo; else return ('c:\dummy.jpg'); end if;
where var_photo is the variable where the image is being stored.
That did not work also.
So I am out of options please help me with this problem.
Many thx for all.