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 use dynamic SQL with IR?

Sgodavar-OracleJun 15 2018 — edited Jun 18 2018

I'm using APEX 5.1.1. I have a classic report with dynamic sql(plsql function body returns SQL). is it possible to convert this to IR or  have Interactive report with dynamic sql, as my query keeps changing from the UI, including the view name, order by etc., any ideas are appreciated, thanks/

This post has been answered by Mahmoud_Rabie on Jun 16 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2018
Added on Jun 15 2018
3 comments
1,853 views