Home » Developer & Programmer » Forms » Image item clearing and image not loading (Oracle Forms 11g)
Image item clearing and image not loading [message #677903] Mon, 21 October 2019 12:00 Go to previous message
Messages: 3
Registered: October 2019
Junior Member
I am attempting to use the read_image_file procedure in Forms to show product images to the user. We store the file name of the images in our database.
It is working for most product pictures, except one picture does not display, however, in 'other' of our developed forms, it 'does' display.
We have a remote directory we use to store all the product files.
All files are *.jpg files.

I am using, in forms, a WHEN-NEW-RECORD-INSTANCE trigger to populate the image for each record.
I have multiple records in the block, however the image is only supposed to display for each record and there is only one instance of the image item for the block.
Please give me some ideas to look for problems and how to potentially solve them.

my command for read_image_file looks like this:

Why the picture shows on some of our forms and not on this one, when we are using the same code to call it, I am bumfuzzled. Also why other product images are showing when I go into those records, and this one product does not is also bumfuzzling.

Since I couldn't pull the product in, I attempted to 'clear' the previous image from the image item using:

However this isn't doing what I expect either.
I have attempted if not FORMS_SUCCESS then
send a message;
and when others then
send a message;

Neither of these worked either. It's like the form doesn't send back an error when read_image_file doesn't find the picture to display it, or the format of the picture is bad?

Any assistance would be greatly appreciated.

At this point I am thinking there could be an issue with the file to display, or the name of the file, stored in the database column, but wouldn't other forms we have created have the same issue?
Read Message
Read Message
Read Message
Previous Topic: Can UTL_HTTP be used in the forms.
Next Topic: localhost
Goto Forum:

Current Time: Tue Jan 28 17:25:37 CST 2020