Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid Images in Oracle Forms

Kevin WakleyJun 13 2012 — edited Aug 10 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2012
Added on Jun 13 2012
17 comments
2,787 views