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!

Select list not working

Pritam DasFeb 28 2022 — edited Feb 28 2022

Hi Expert,
I have a one page item which is select list type and i have used sql query for the data.Below is my query which is running perfectly if i ran and displaying 707 rows in sql developer. but same query is not working in Apex select list.
query:
select table_name from user_tables ut where not exists (
SELECT
1
FROM
dm_entities
WHERE stg_table=ut.table_name
)
error message: Column "TABLE_NAME" specified for attribute "" has not been found in data source!
Is there any limitation in select list to display data.

Comments
Post Details
Added on Feb 28 2022
4 comments
1,987 views