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!

read_image_file displaying one image but not another

Peter RauxlohJun 7 2019 — edited Jun 28 2019

Hello all,

I have done much experimenting and boiled down this problem as much as I can.

I have a button in a block which has the following code in it's WHEN-BUTTON-PRESSED trigger

READ_IMAGE_FILE ('C:\Temp\IMAGES\1S18STJEX\2019\04\image1.jpg','jpg','btest.image2');

This shows the image image1.jpg in the field 'btest.image2' which is item_type=image

Fine.

However when I alter it to load a different JPG file, solely by changing the JPG filename it displays the message

'Cannot read image file C:\Temp\IMAGES\1S18STJEX\2019\04\image2.jpg'

No other error message is displayed.

I have eliminated the following

Simple mis-spelling of file names - No. Tested by pasting same link to WE and the images displays fine
Image size - Both images are small 50k and 78k respectively and have similar dimensions 400 x 600
Resolution - The same both are 300dpi
Format - The same, both are JPGs
Path - The same - they are both in the same directory
Filename length - The same
The image display field in the form - The same display field was used with the same settings.

The Functional settings of the display field btest.image2 in the form are

Image format = JFIF
Image Depth = RGB
Display quality=Medium
Sizing style=Adjust

The second image does come from a different source and the EXIF data of the two JPGs has some differences. Is there a limitation of the READ_IMAGE_FILE routine with respect to EXIF data?
I appreciate your help and can upload examples of a working and non-working image.

Hopefully there is a blindingly obvious solution!!

My Forms platform is :

Forms [64 Bit] Version 12.2.1.1.0 (Production)

Cannot obtain ORACLE version number

Oracle Toolkit Version 12.2.1.1.0 (Production)

PL/SQL Version 11.2.0.3.0 (Production)

Oracle Procedure Builder V12.2.1.1.0 - Production

PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)

Oracle Query Builder 12.2.1.1.0 - Production

Oracle Virtual Graphics System Version 12.2.1.1.0 (Production)

Oracle Tools GUI Utilities Version 12.2.1.1.0 (Production)

Oracle Multimedia Version 12.2.1.1.0 (Production)

Oracle Tools Integration Version 12.2.1.1.0 (Production)

Oracle Tools Common Area Version 12.2.1.1.0

Oracle CORE 11.2.0.3.0 Production

Java Version: Oracle Corporation, 1.8.0_77

My database platform is

Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production in the Oracle cloud on a Linux box

WLS is

WebLogic Server Version: 12.2.1.1.0

Thanks

Pete

This post has been answered by Michael Ferrante-Oracle on Jun 11 2019

Jump to Answer

Added on Jun 7 2019

#forms, #moved-from-devops

21 comments

2,368 views