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
Problemas no Upload - Webutil
- dr_gori
- Moderador
- Mensagens: 5024
- Registrado em: Seg, 03 Mai 2004 3:08 pm
- Localização: Portland, OR USA
- Contato:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Fala Victor !!!
Você ta fazendo upload de uma IMAGEM JPG ? Se sim, tem um PAPER no metalink falando sobre isso:
A solução é essa:
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:
Pelo que eu vi, uma outra solução é abrir o JPG no PAINT e salvar eleSolution
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.
-
- Informação
-
Quem está online
Usuários navegando neste fórum: Nenhum usuário registrado e 9 visitantes