title: How to dynamically generate url for image map in Oracle ApEx?
body: <p>The scenario:</p>
  
  <p>I have an ApEx page which pulls a record from a table. The record contains an <code>id</code>, the <code>name</code> of the chart (actually a filename) and the code for an <a href="http://www.w3schools.com/tags/tag_map.asp" rel="nofollow" title="w3 schools">image map</a> as an <code>NVARCHAR2</code> column called <code>image_map</code>.</p>
  
  <p>When I render the page I have an embedded HTML region which pulls the image in using the <code>#WORKSPACE_IMAGES#&amp;P19_IMAGE.</code> substitution as the <code>src</code> for the image.</p>
  
  <p>Each chart has hot spots (defined in the <code>image_map</code> html markup) which point to other charts on the same ApEx page. I need to embed the:</p>
  
  <ul>
  <li>Application ID (like <code>&amp;APP_ID.</code>)</li>
  <li>Session (like <code>&amp;APP_SESSION.</code>)</li>
  </ul>
  
  <p>My problem:</p>
  
  <p>When I try to load the <code>&amp;APP_ID</code> as part of the source into the database it pre-parses it and plugs in the value for the ApEx development app (e.g. <code>4500</code>) instead of the actual target application (<code>118</code>).</p>
  
  <p>Any help would be greatly appreciated.</p>