Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Popup Lov returns 'No results found.' when a page item is used in the SQL query as List of Values

Robin BijuJun 23 2022 — edited Jun 23 2022

Hi,
Popup Lov returns 'No results found.' when a page item value is used in the SQL query as List of Values in Apex version 22.1.1. Patch 34020981 is already applied.
For example,
p123_dep_id is a page item that holds the department id. (Say 100)
And Popup LOV is,
SELECT first_name
FROM employees
WHERE department_id = :p123_dep_id
It doesn't return any values.
If I hardcode the value 100 instead of the page item, it returns the desired output.
Any help is appreciated.
Thank You.

This post has been answered by fac586 on Jun 23 2022
Jump to Answer
Comments
Post Details
Added on Jun 23 2022
5 comments
890 views