This time, I'll show how to build a simple image gallery using Oracle Application Express (APEX) and taking advantage of Jquery framework capabilities. But first of all, follow the link to see the magic happening ;)
There are several slideshow or gallery plugins for Jquery. You can choose the one you like more and re-adapt the code to fit the plugin requirements. My choice was Pikachoose.
Pikachoose is a lightweight Jquery plugin that allows easy presentation of photos with options for slideshows, navigation buttons, and auto play.
Lets begin creating a simple database structure to store the images.
Create a sequence to be used by image id:
Create a table to store the images:
Now on APEX, following the wizard, create a data entry form based on "GAL_IMAGES" table.
Go to Shared Components>Application Items and Create an Application Item. Ex: G_IMAGE_ID.
Create an Application Process to retrieve the image from the database. Identify the point at which this process will run as "On Demand". The point of "On Demand" is that it will only fire when requested by a page process.
Now create the page where you want to put the image gallery and then, Edit Page > HTML Header:
On the same page, create a PL/SQL Dynamic Content region: