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!
I'm creating an ad-hoc report/chart creation tool that allows the user to create basic reports/charts through a UI and I then generate the SQL. I want to create pages from a template (exported page) and inject the sql into, them all through code. I have been trying to find some info on this matter and it's not easy to find, the most I've been able to scrape togeather is "wwv_flow_api.id(wwv_flow_id.next_val) " to autogen ID's and then the "apex_application_install" package to init before importing the page. My problem now is that I'm not sure how I should be using the "apex_application_install" package to init all the right variables that allow me to just run the modified page export without problems, currently I just get this error "ORA-20001: Application ID and current security group ID are not consistent."