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!

Bug in PL/SQL Function Body returning SQL Query

user557273Feb 7 2024

Hi all ,

I am trying to add popup Lov item with lis of values Type “Function Body returning SQL Query”

when i am using pind variables it's rais an validation error

"ORA-20999: Parsing returned query results in "ORA-20999: Failed to parse SQL query! ORA-06550: line 2, column 169: ORA-00936: missing expression"."

put when i ignore this error with save the page error disapear.

check attached screenshot.

after_save_page.JPG

ErrorDesc.JPG

after_close_poup.JPG

after_validate_in_poup.JPG

Comments
Post Details
Added on Feb 7 2024
1 comment
714 views