| error - rep-0108 file '- - - - - .jpg' not found [message #589939] |
Fri, 12 July 2013 05:03 |
 |
subhash_pandit
Messages: 1
Registered: December 2012
Location: delhi
|
Junior Member |
|
|
hi,
i am using report 6i to display image from a file path .when no image there it gives
rep-0108 file '............20132.jpg' not found. all images are in .jpg format.
query is
FUNCTION cf_1formula RETURN CHAR IS
tiff_image_dir VARCHAR2 (200) := :p_coll_photo;
photo_filename VARCHAR2 (200);
BEGIN
photo_filename := tiff_image_dir || :myear || :mroll_no || '.' || 'JPG';
IF NVL (photo_filename, 'X') = tiff_image_dir
THEN
RETURN NULL;
ELSE
RETURN photo_filename;
END IF;
EXCEPTION
when no_data_found then
return (:p_coll_photo||'no_image.jpg');
When Others Then
if sqlcode=-302000 then
return (:p_coll_photo||'no_image.jpg');
end if;
END;
thanks in advance.
[Updated on: Sat, 13 July 2013 02:38] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
