3 Replies Latest reply: Feb 26, 2014 12:56 AM by Nicolette RSS

Reusing Cascading LOV in Multiple pages?

thtsang Journeyer
Currently Being Moderated

For example, if you have page items for Car Make and Model, Model would identify Car Make as the Cascading LOV Parent Item so that whenever Car Make is changed, the LOV for Model would be refreshed. (Copied from documentation :P)


So, the query in Car Model LOV is defined as


select car_model d, car_model r
from car_models
where car_make=:CAR_MAKE


And in the page, I define a page item CAR_MAKE and use it as the "Cascading LOV Parent Item(s)". So far so good.


I want to use this LOV in another pages. The problem is, APEX disallow me to create CAR_MAKE in another page, saying that "Item name is already used by another application or page item."


Besides creating the same LOV for each page (only using different bind variable name), is there any solution?


I thought of using a dynamic action set copy the Car Make to an Application Item, and reference the Application Item in the LOV. Is it guaranteed that the dynamic action complete before the LOV is refreshed?


Application Express

Oracle 11g XE


  • Correct Answers - 10 points
  • Helpful Answers - 5 points