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!

Need to get row count from an interactive report

I am on Apex 21.1 and trying to have a page item set on the after refresh event of an interactive report. I have seen code online that does something similar but have noted Oracle has labeled the function APEX_IR.GET_REPORT as deprecated. I have tried working with the suggested replacement function OPEN_QUERY_CONTEXT but it returns a json object through a context..
Does someone have a function or something that can handle this? The closest I have come builds a collection of rows which will have issues since some of the reports involved will return more than 10,000 rows..
Thanks!
Tony Miller
White Rock, NM

Comments
Post Details
Added on Oct 6 2022
4 comments
3,207 views