This is something different for a Oracle apps developer to create an image gallery of some objects for an application. This can be easily achieved by following steps.
Step 1 : Create an Application Level item (Ex: G_IMAGE_ID).
Step 2 : Create an Application Process with On Demand Run.
PLSQL Code for the Process..
Step 3 : Create a PLSQL Region in the page where you are going to display your images.
Step 5 : Create an page level item (Ex: P1_Image_ID)Step 6 : Put this function on your page Function and Global variable declaration section. This function will allow us to select images in the gallery dynamically.animated_js.js (Javascript File)
Step 7 : Put this css on your page Inline section. This will align in the thumbnails and fix the height and width of the image and thumbnails .Image_gallery_css.css (CSS File)Step 8 : Create a page with form to upload your images to the table , so that we can display the same in our page.
Step 1 : Create an Application Level item (Ex: G_IMAGE_ID).
Step 2 : Create an Application Process with On Demand Run.
PLSQL Code for the Process..
Step 3 : Create a PLSQL Region in the page where you are going to display your images.
Step 4 : Put this on region header and footer.
Step 5 : Create an page level item (Ex: P1_Image_ID)Step 6 : Put this function on your page Function and Global variable declaration section. This function will allow us to select images in the gallery dynamically.animated_js.js (Javascript File)
Step 7 : Put this css on your page Inline section. This will align in the thumbnails and fix the height and width of the image and thumbnails .Image_gallery_css.css (CSS File)Step 8 : Create a page with form to upload your images to the table , so that we can display the same in our page.
Test the application by uploading and clicking on thumbnails.... Click Here (APEX URL)
Login with your Name :D
this query return one row only .. how to get multi images ?
ReplyDeleteselect "mime_type","image_content","image_name",dbms_lob.getlength("image_content")
into l_mime,lob_loc,l_file_name,l_length
from "xx_images"
where image_id = :image_id;