I'm fairly new to developing with Oracle Apex 5 and using PL/SQL.
I've been trying to add a cascading LOV to my application so when the select list item of Review Focus is changed, it will change the child Review sub-focus LOV based on that selection. I've tried a mix of dynamic actions and shared components but nothing seems to work.
This is my current attempt where this code is inputted in the PL/SQL function returning a query section. I have the cascading parent LOV set to the Review Focus item. I have not activated any processes or dynamic actions.
CASE upper(:P4_REVIEW_FOCUS)
WHEN 'WILDLIFE' THEN :P4_REVIEW_SUBF := 'marine birds';
WHEN 'CLIMATE' THEN :P4_REVIEW_SUBF := 'meterorology';
ELSE :P4_REVIEW_SUBF := null;
END CASE;
I will then try to add more assignments to the child LOV assignment once I get it fixed!