APEX

Hello there :)

I'm having an issue with showing images in my jquery image gallery; it's taken me all day and it just won't work. I've tried to follow this tutorial using the latest version of pikachoose 3.0. http://apex-notes.blogspot.com/2008/12/build-image-gallery-using-apex.html


What I see is nothing but broken image links and no jquery image gallery at all. I suspect the problem is with this PL/SQL statement but I am not sure. I use BLOBs for images.

DECLARE
   CURSOR c1
   IS
      SELECT "IMAGE_ID"
        FROM "GAL_IMAGES";
BEGIN
   HTP.p ('<ul id="pikame">');

   FOR gallery_rec IN c1
   LOOP
      HTP.p
         ('<li>
                <img src="f?p=&APP_ID.:0:&SESSION.:APPLICATION_PROCESS=gallery:::F106_G_IMAGE_ID:'||gallery_rec.image_id||'" /></li>'
         );
   END LOOP;

   HTP.p ('</ul>');
END; 

Please help?