Invalid Images in Oracle Forms
Hi!
I've got a Forms 10g form which displays a TIFF image in a BLOB image item.
Everything works really well except that some of the images are corrupt/incomplete. A problem occurs when I perform a global query in the form and then scroll through the records.
It appears that the form tries to load the corrupt image, fails, doesn't return an error, and leaves the image from the previously record displayed.
In detail:
- x records in the database with an image stored in a BLOB item.
- Perform a global query in the form which returns and displays, amongst other things, the image.
- Every record is correctly displayed, including image.
- A record exists where the image is corrupt/incomplete:
When scrolling to this record no error is returned, every item is correctly updated, except for the image.
The image from the previous record remains displayed.
I have the following questions:
- Can I test a forms image item to see if the contents are 'valid'?
- Can I perform a test after a forms query to check that image has been loaded correctly?
- Can I test a BLOB column in the database to see if it contains a valid image?
- Is there something I can do to ensure that the image item is empty when there's a problem with a loaded image?
Any help would be greatly appreciated.
Thanks,
KEvin