I created a page in APEX 4.2.3.00.08. I added two text field page items named P3_FROM_RANGE & P3_TO_RANGE. I also defined a dynamic action on the page named GET_RANGE with the following sql in the PL/SQL Code property under Settings for the True Action:
begin
select grt.from_key_fob_num
, grt.to_key_fob_num
into :P3_FROM_KEY_FOB_NUM, :P3_TO_KEY_FOB_NUM
from apextds.gen_range_tab grt;
end;
The GET_RANGE dynamic action is programmed to execute when :P3_TDS_NUM CHANGES VALUE. That is to say the WHEN properties of the dynamic action are:
Event: Change
Selection Type: Item(s)
Item(s): P3_TDS_NUM
Condition: not equal to
Value: ALL
When I change P3_TDS_NUM the session state indicates the dynamic action is executed for the indicated conditions and the text field page items :P3_FROM_KEY_FOB_NUM, :P3_TO_KEY_FOB_NUM have the correct values but they do NOT display on the page. (If I edit the page and then apply changes and run the page the correct values appear, obviously not a run-time scenario.)
How do I refresh the text field page items so the values appear when the dynamic action is executed? Is this an issue with a page property, an item property, or the dynamic action properties?