Skip to Main Content

APEX

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!

All Image appear as the same in interactive report..APEX 4.2.

Ahmed.FJun 2 2013 — edited Jun 14 2013
Hi, i worked with oracle apex 4.2.2 ,window 7,theme 25

i have faced the problem when i create interactive report with BLOB column ,i create sample report and i used GET_BLOB_FILE_SRC Function to show the image in report but i face these problems
1- the images don't appear when i run the report and all images are blank
2- i must press edit on any column and go to edit page then back to report again and the image appear
3- all record have the same image ( the image with id which i pressed )
i mean when i pressed the record with ID 1 and go to edit page and then back to report the image with ID 1 appear in all record in report ,and when change the id the same issue appear . i don't know what the problem .
pls advice me

Thanks
Ahmed
This post has been answered by fac586 on Jun 3 2013
Jump to Answer

Comments

fac586
Answer
Ahmed.F wrote:
Hi, i worked with oracle apex 4.2.2 ,window 7,theme 25

i have faced the problem when i create interactive report with BLOB column ,i create sample report and i used GET_BLOB_FILE_SRC Function to show the image in report
Didn't it occur to you that it is important to include exactly how you used the function in the report? What is the report query?
but i face these problems
1- the images don't appear when i run the report and all images are blank
2- i must press edit on any column and go to edit page then back to report again and the image appear
3- all record have the same image ( the image with id which i pressed )
i mean when i pressed the record with ID 1 and go to edit page and then back to report the image with ID 1 appear in all record in report ,and when change the id the same issue appear . i don't know what the problem .
Sounds like you're passing item values from the edit page to the function rather than column values from the report. See the SELECT example in the <tt>apex_file.get_blob_file_src</tt> to see how to use the function in a report. The values of <tt>p_v1</tt> (and <tt>p_v2</tt> if required) should come from report columns, not page items.

Why do you need to use the function at all? Using declarative BLOB formatting is recommended.
Marked as Answer by Ahmed.F · Sep 27 2020
Ahmed.F
Thanks lot Fac for fast response

the problem solved ...i passed the page item as a parameter not report item ....sorry :)


thanks
Ahmed
patfmnd

Can you explain how you got the image to show?  I have a similar issue with trying to GET a blob image using RESTful web service.  I am putting the BLOB field into a collection item 'BLOB001' , but I cannot figure out how to get the Image to actually render in a report with that BLOB item:

select blob001 "image_blob"

from apex_collections

where collection_name = 'P5_DOREST_RESULTS'

The declarative Blob Column Attributes section does not accept the collection above as a table so it won't set the attributes.  Is the only alternative to load the BLOB into a table and then create a report on that?

Thanks,

Pat

GBara

See here on working with APEX Collections from Web Services: http://www.apexninjas.com/blog/2011/05/using-rest-web-services-in-apex/

And rendering images from BLOB:  http://www.apexninjas.com/blog/2011/09/uploading-and-displaying-images-in-apex/

Regards,

George

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 12 2013
Added on Jun 2 2013
4 comments
467 views