Monday 29 August 2016

Oracle APEX Image Gallery

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 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 





Sunday 1 May 2016

Oracle APEX

Oracle application express is a free web based application creating tool given by Oracle to its customers...

There is no need for the EBS apps or Oracle forms to launch these applications... It can be accessed by the URL...

No need for EBS login if we are making the application for public, it can be accessed by anyone on single sign on...