title: Set value dynamic action not working in apex
body: <p>I have a problem creating sql dynamic action in oracle apex v4.2. I have two fields, Department number and department name. Department number is a text field with autocomplete. The department name is a display field. On changing the department number, the department name should be displayed by an sql query. </p>
  
  <p>I created a set value dynamic action on department number, giving the correct values in page item to submit and the correct sql query referencing P3_DEPARTMENT_NO. </p>
  
  <p>When i run the page, after select a department number, the department name is not coming up automatically. </p>
  
  <p>Could you please suggest on what i might be missing. </p>
  
  <p>Thanks in advance. </p>