title: Issue using Select Named LOV in Oracle Application Express
body: <p>I am using Application Express 3.2.1 and I have an application that when run pulls these columns from a database:</p>
  
  <p>Display Name, Email Address, Phone Number, Home Network, Country</p>
  
  <p>I want to make a way to filter the rows by Country, so I created a Select Named LOV with this values definition:</p>
  
  <pre><code>select name d, name v
  from 
  (
      select distinct(country) name
      from hh_carriers 
  )
  </code></pre>
  
  <p>When I click "Run" for my application, all my data is displayed correctly and my select list populates correctly. However, when I select a "Country" from my select list, the data doesn't change. The select list also goes back to the default value. Is there something else I have to do with the Select Named POV? What do I have to do to make the filter work? Thanks.</p>
  
  <p>This is what my SQL statement looks like to generate my page:</p>
  
  <pre><code>select * from hh_carriers
  where
  country like :P5_COUNTRY
  </code></pre>
  
  <p>Display Extra Values: No<br>
  Source Used: Only when current value in session state is null<br>
  Source Type: Static assignment (value equals source attribute)  </p>
  
  <p>Edit: Changed some things for clarity</p>