Problemas no Upload - Webutil

[victorpsl]

Bom dia!!!

Galera, depois de um bom tempo instalando e configurando o webutil, fomos executar o forms, porém ao clicar na ação onde executa o procedimento que efetua o upload do arquivo para o banco a rotina simplesmente trava e fica rodando, rodando, rodando, rodando... até que surge o seguinte erro: FRM-92101.

Alguém já implementou uma rotina desta em um forms?

Espero que possam dar uma força!!

Tks

[dr_gori]

Fala Victor !!!
Você ta fazendo upload de uma IMAGEM JPG ? Se sim, tem um PAPER no metalink falando sobre isso:

READ_IMAGE_FILE Fails With FRM-47100 For JPG's Stored In Exif Type Format. [ID 402773.1]

Modified 13-DEC-2010 Type PROBLEM Status PUBLISHED

In this Document
Symptoms
Changes
Cause
Solution
References

Applies to:

Oracle Forms - Version: 6.0 to 11.1.1.3.0 - Release: 6 to
Information in this document applies to any platform.
***Checked for relevance on 13-Dec-2010***
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 files 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 contains Exif (Exchangeable image file format) information. 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: "Progressive JPEG" format is not supported in Forms. Only "BaseLine JPEG" format is supported (JFIF in the header). Most of the Image formats which have Exif info (Digital Cameras' additional info) are not properly recognized by Forms.

The problem is not just related to JPEG/JPG images that contain EXIF information, but also TIFF files as well. See (not a bug) Bug 8571482.

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 fine, 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 internal enhancement request has been logged with development:

Bug:1197043- ENH PROVIDE SUPPORT FOR READ_IMAGE_FILE READING IMAGE With EXTENSION .EXIF

The enhancement request as of date (Dec-2010), is with the Oracle review board to consider if this will be implemented or not.

References

BUG:5135787 - FRM-92101 ERROR WHEN OPENING A PICTURES IN AN ITEM TYPE ''IMAGE'' IN FORMS
BUG:8571482 - TRYING TO IMPORT A TIFF IMAGE INTO FORM GOVES ERROR: VGS-507
BUG:1197043 - ENH: PROVIDE SUPPORT FOR READ_IMAGE_FILE READING IMAGE WITH EXTENSION .EXIF

Related
Products
Middleware > Developer Tools > Database & PLSQL > Oracle Forms
Keywords
TIFF; EXIF; JPG; IMAGE; PICTURE
Errors
FRM-92101; FRM-47100; 92101 ERROR

A solução é essa:

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 fine, 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.

Pelo que eu vi, uma outra solução é abrir o JPG no PAINT e salvar ele