Oracle Forms

Hi guys,

Im currently having issues with images on Oracle forms 10g. Firstly, I have created a form where I can upload and save an image, when you press the upload button it displays the photo for the user to see, or when querying it will bring back the photos stored on the database. Now, some of these photos display fine but others dont display on the form however if i were to open them and save them(without making a single change) using any program like ms paint the photo displays fine on the form. I have spent ages trying to figure this out and just cant, its not down to size and there doesnt seem to be any obvious differences in the photos which display properly and those which dont.

As this issue alone was driving me crazy I decided to use a java bean to display my photos as they always seem to display correctly when using a java bean. However, to get them to display in the java bean I need to write the exact sql statement to retrieve the photo, which is fine. I am now running into isses though because the datablock I want to display the photos on is a multi record block and I need the exact id of the photo for my javabean otherwise when it queries the photo it just brings back one of the photos (the multi record function doesnt seem to work for the javabean). Does anyone here know how I would get the id from each of the records in the multi record block?

For example I can see 3 records on my multi record block, my javabean gets the id of record and fetchs the photo using sql ie select photo from photos where id = ** but I need to get the ids from the other multirecord items, how do I obtain the other ids from the multi record block (its difficult because it is just one item in the datablock and not 3 seperate items).

Any help on this matter would be GREATLY appreciated.

Thanks.