Generic solution for cascading select lists/lovs

Note: Before you read on, cascading LOVs are now natively implemented into APEX 4.0. See my related blog posting Oracle APEX 4.0: Cascading LOVs/Select Lists.

After implementing several times a select list/popup lov, which is depending on another item on the same page (see the AJAX example from Carl Backstrom), I thought that it was time to come up with a more generic solution where I don’t have to implement javascript code and on-demand processes for each lov anymore.

I thought if the render engine of Oracle Application Express (APEX) is able to generate the SQL statements on the fly, I should be too 😉

Continue reading