Version: 5.1.1.00.08
Universal Theme
Hello,
I have a classic report to display images in full size that is called from other pages where a thumbnail of the image is displayed. When the thumbnail is image is clicked this page is called to display the full image.
This is the how it's called:
SELECT CASE
WHEN NVL (DBMS_LOB.getlength (blob_content), 0) = 0 THEN NULL
ELSE CASE
WHEN file_mimetype LIKE 'image%' THEN DECODE
(
NVL (DBMS_LOB.getlength (blob_content), 0)
,0, NULL
,'<a href=" '
|| APEX_UTIL.prepare_url ('f?p=' || :APP_ID || ':53:' || :APP_SESSION || '::' || :DEBUG || '::P53_FILE_INDEX:' || file_index)
|| ' "><img alt=" '
|| file_name
|| '" title="'
|| file_name
|| '" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '
|| 'src="'
|| APEX_UTIL.get_blob_file_src
(
'P36_BLOB_CONTENT'
,file_index
)
|| '" height="75" width="75" /></a>'
)
FROM ....
.
This displays the thumbnail of the image and when the image is clicked the image is displayed full view, but the viewer has scroll bars and I would like to know how to have the viewer auto size to show the entire image.
The query for the report to view the full size of the image is:
SELECT file_index
,DBMS_LOB.getlength (blob_content) blob_content
FROM ib_assets
WHERE file_index = :P53_FILE_INDEX
The FILE_INDEX is the primary key and is hidden.
The BLOB_CONTENT is set to 'Display Image'. The image displays, but the window is a fixed width and height and I don't see where that is set.
I'd like the view window to auto size to the size of the image (the images can be different sizes).
Can someone help me with how to achieve this?
What additional information can I provide?
Thanks,
Joe