Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Image galary display based on next & previous button

VedantNov 29 2013 — edited Dec 5 2013

Hi,

I am showing Image galary on next & previous buttons.i am writting this code on region type( pl/sql anonymous block). it i sgiving the error

  • ORA-06550: line 24, column 34: PLS-00103: Encountered the symbol "?" when expecting one of the following: ) , * & - + / at mod remainder rem <an exponent (**)> and or using || multiset.

in code my <img src="images/001.jpg" class="cube" /></a>   line  i want to replace with my table images.what should i write here .In source what should i write.

my code is:-

{code}

DECLARE

rec INT_IMAGE_GALLARY%rowtype;

v_id varchar2(10);

begin

htp.p('

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Intercruises</title>

    <link href="#WORKSPACE_IMAGES#skitter.styles.css" type="text/css"

media="all" rel="stylesheet" />

    <script src="#WORKSPACE_IMAGES#jquery-1.6.3.min.js"></script>

    <script src="#WORKSPACE_IMAGES#jquery.easing.1.3.js"></script>   

    <script src="#WORKSPACE_IMAGES#jquery.skitter.min.js"></script>

<script>

  $(document).ready(function() {

  var options = {};

  if (document.location.search) {

  var array = document.location.search.split('=');

  var param = array[0].replace('?', '');             // This line is giving Error ?

  var value = array[1];

  if (param == 'animation') {

  options.animation = value;

  }

  else if (param == 'type_navigation') {

  options[value] = true;

  if (value == 'dots') $('.border_box').css

({'marginBottom': '40px'});

  }

  }

  $('.box_skitter_large').skitter(options);

  // Highlight

  $('pre.code').highlight({source:1, zebra:1, indent:'space',

list:'ol'});

  });

  </script>

</head>

<body>');

FOR REC IN (SELECT id,dbms_lob.getlength("GALLARY_IMAGE") AS GALLARY_IMAGE FROM INT_IMAGE_GALLARY WHERE upper(IMAGE_NAME) LIKE upper('Interc%'))

LOOP

htp.p('

<table width="560" border="0" cellpadding="0" cellspacing="0">

  <tr>

    <td><div class="box_skitter box_skitter_large">

  <ul>

    <li><a href="#cube"><img src="images/001.jpg" class="cube" /></a>   // i have to add my table images here how can i write code here to display images

  

      <div class="label_text">

        <p>cube</p>

      </div>

    </li>

</ul>

</div></td>

  </tr>

</table>');

end loop;

htp.p('</body>

</html>');

end;

{code}

thanks & Regards

Vedant

This post has been answered by Pars on Dec 5 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2014
Added on Nov 29 2013
14 comments
927 views