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!

How to call Apex Advisor from PLSQL

forintiJun 19 2019 — edited Jun 22 2019

I would like to call Advisor from PLSQL. I haven't found any documentation.

Looking at the packages and the HTML, I gathered that it would be something like this:

declare

  options wwv_flow_global.vc_arr2;

begin

  options(1):='BRANCH_SEQUENCE';

  apex_050000.wwv_flow_advisor_dev.check_application(p_application_id=>300, p_check_list=>options);

end;

But this only produces ORA-01403: no data found.

Is this possible at all?

This post has been answered by forinti on Jun 21 2019
Jump to Answer
Comments
Post Details
Added on Jun 19 2019
5 comments
1,089 views