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 problem on IG when using PL/SQL function body returning SQL Query

SmithJohn45Sep 30 2020 — edited Sep 30 2020

hi all,
WS: ptmws user: developer pwd: Infra123 app: TESTS page: 22 IG Test Select List
i had a problem with Select List in IG which used PL/SQL function body returning SQL Query,
-- when i pass columns it is showing error
-- when i pass literal values it is fine
definitely i am passing parameters wrong way, please guide me to correct this problem.
screenshot #1: it is showing that i am doing wrong (pass columns)
IG-SelectList-Problem_Scr02.jpg
screenshot #2: it is showing i am doing right (pass literal values)
IG-SelectList-Problem_Scr01.jpg

Comments
Post Details
Added on Sep 30 2020
5 comments
1,249 views