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!

PL/SQL Func Body returning SQL Query is not validated when the SQL statment is from a page item.

Old XuNov 29 2024

I create a report with the source from PL/SQL Func Body returning SQL Query.

When the SQL statement is a written fixed in the body, it works.

But if the SQL statment is from a page item, validation is failed with error message: ORA-20999: PL/SQL function body did not return a value.

Comments
Post Details
Added on Nov 29 2024
10 comments
216 views