title: oracle apex list of values - select value and use in SQL query in next field
body: <p>I'm using Apex 4.0.2 with Oracle XE 11. </p>
  
  <p>I have a form on which a field, <code>P200_CARD_TYPE</code>, is set from a List of Values.  What I want happen is to use that value I select in a query that sets a "Display Only" field, <code>P200_DESC</code>  </p>
  
  <p>In the Source section for <code>P200_DESC</code>, I have "Source Type" set to "SQL Query":</p>
  
  <pre><code>SELECT CARD_DESC
    FROM CARDTYPE
   WHERE card_type = :P200_CARD_TYPE;
  </code></pre>
  
  <p>The problem I have is getting Apex to behave in this way.
  For <code>P200_CARD_TYPE</code>, if I have "Page Action when value changed" settings to "Redirect and Set Value", the <code>P200_CARD_TYPE</code> variable does appear to be set, (I write it out to a table) but</p>
  
  <ol>
  <li>It does not remain in the field display, (goes back to my null display setting)</li>
  <li><code>P200_DESC</code> does not recognize the <code>P200_CARD_TYPE</code> bind variable</li>
  </ol>
  
  <p>If on <code>P200_CARD_TYPE</code>, I have for "Page Action when value changed" setting so of none, my selection is retained on screen but I cannot persist to the table and <code>P200_DESC</code> still doesn't seem to recognise it.</p>
  
  <p>I would've thought once I've made my selection from the LOV, <code>P200_CARD_TYPE</code> is set and I can use it elsewhere.</p>