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!

Chart based on PLSQL Function Body

DernbauerApr 15 2017 — edited Apr 15 2017

Next Issue.

I created a Dynamic Action wich calls a Function and returns a SQL String. By clicking the execute the SQL statment will be returned.

This part works as expected.

pastedImage_0.png

The call ("Butten Execute" is as follows:

pastedImage_1.png

And the setting:

pastedImage_2.png

here is the function call:

begin

l_query := create_DQ_QRY(:P410_CONDITION,:P410_CONDITION_VALUE_ONE,:TABLE_ID,:ATTRIBUTE_ID);

wwv_flow.debug(l_query);

return l_query;

end;

Would I would like to to and to archive is to create a Chart Region with the same Query but I got the Error Oracle no data found.

pastedImage_10.png

This post has been answered by Pierre Yotti on Apr 15 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2017
Added on Apr 15 2017
3 comments
420 views