Oracle Form Webutil exception: Cannot Read Image File

由于用户的需要，在Form上增加了图片上传数据库的功能，同时对应的WEB系统JSP页面可以从数据库读取显示上传至数据库中的图片。在实际应用中发现由于Form上image域的image format属性设置，造成JSP页面不能显示图片的异常。当把image format调整为BMP后，JSP页面显示图片才正常。可能这与存入数据库中图片的数据格式有关联。同时，在开发过程中也遭遇到了webutil的Bug，屏幕报“Cannot read imae file ... ...”异常信息。经比对和查找在网络上找到了相关说明的信息，下面将说明信息进行摘抄以备后续之用。

 

----------------------------------------------- 摘    抄 --------------------------------------------------------

Subject: READ_IMAGE_FILE Fails With FRM-47100 For JPG's Stored In Exif Type Format.
Doc ID: Note:402773.1 Type: PROBLEM
Last Revision Date: 14-MAR-2007 Status: PUBLISHED

In this Document
Symptoms
Changes
Cause
Solution
References

Applies to:
Oracle Forms - Version: 6.0.8 to 10.1.2
This problem can occur on any platform.
Symptoms
On trying to insert or upload an image with the forms built-in READ_IMAGE_FILE you get the following FRM error.

FRM-47100 : Cannot Read Image File

The same occurs when using Webutil function CLIENT_IMAGE.READ_IMAGE_FILE. However, other image file have no problem being read into forms.

Changes
It seems most of the jpg files that cannot be uploaded are created from digital cameras.
Cause
The failing image is in an Exif (Exchangeable image file format) format. Forms cannot read jpg's which have this format.
From the following bug,

Bug 5135787 - FRM-92101 ERROR WHEN OPENING A PICTURES IN AN ITEM TYPE ''IMAGE'' IN FORMS

development have commented the following.

"Please note: Progessive JPEG" format not supported in Forms. Only "BaseLine JPEG" format is supported (JFIF in the header). Most of the Image format which has Exif info ( Digital Cameras' additional info) not properly recognised by forms.

Digital camera, add the Exif type information such as into a jpg file.
Solution

Since forms cannot read Exif format you will need to remove the exif information from the jpg file for forms to work. This can be done using any 3rd party tools that has this functionality. IrfanView (http://www.irfanview.com/) is one such tool and can be downloaded as freeware.

Of course, removing Exif information for one file is ok, but if hundred's of jpg files need to be converted, then this is very time consuming. InfraView has functionality which will convert all images in a certain directory in batch. See InfraView online help for more information.

The following enhancement request has been logged with development.

Bug 1197043 - ENH PROVIDE SUPPORT FOR READ_IMAGE_FILE READING IMAGE

With EXTENSION .EXIF
( Not public visible )

At this moment it is not planed to apply the Enhancement request.
References
Bug 1197043 - ENH: PROVIDE SUPPORT FOR READ_IMAGE_FILE READING IMAGE WITH EXTENSION .EXIF
Bug 5135787 - FRM-92101 ERROR WHEN OPENING A PICTURES IN AN ITEM TYPE ''IMAGE'' IN FORMS
Errors
FRM-92101
FRM-47100 Cannot read image file .