title: Oracle APEX Cascading Select List Query
body: <p>I am looking to perform the following using a On Demand Ajax call within Oracle APEX 4.2.</p>
  
  <p>Basically, I have an two select lists where the value of the first select list is used to feed into the second select list but I have the following issue.</p>
  
  <p>When I select the value from my first select list, which is then used as part of the where conditions of my second select list, the query that executes as part of the second select list may take up to a minute to return all available results. At the moment, the user switches to the second select list but is empty as the query in the backend Dynamic action is still running.</p>
  
  <p>Using Ajax together with a spinner, I need a means of showing to the user that the second select list is busily processing the available results and so want to display a spinner whilst it is getting the results and then hiding the spinner when the results are all available in the second list.</p>
  
  <p>I think that this would give the user a better user experience.</p>