Skip to Main Content

APEX

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

PL/SQL Function Body returning SQL Query with Value from Application Item

user-ofy61Aug 7 2023

Hello,

i created an PL/SQL Function Body returning SQL Query and want to hand over a value from an application item.

BEGIN
return
test(:APPLICATION);
end;

Does it work with Application Items?

If i put in f.e. manually ‘6’ the function works. It only does not work if i try with it with the application item.

Comments
Post Details
Added on Aug 7 2023
6 comments
676 views