© 2026 LinearBytes Inc.
Search posts, tags, users, and pages
Jochen Zehe
Improvement 2: Ability to pass in parameters from the calling page.
Jon Dixon You could use Source Type = "Function Returning SQL" instead of a SQL Query.
return lov.get_emp_list ('P' || :APP_PAGE_ID || '_DEPT_ID');"
Jon Dixon
APEX, ORDS & the Oracle Database
Thanks for the idea Jochen. That would work. I was just trying to nudge Oracle into adding the ability to do this declaratively :)