Hi all,
I have a report region in my page that I would like to be auto refreshed after every 5 seconds. The data in the reports underlying table is generated using a procedure. I need to call the procedure after every 5 seconds which will refresh the table, and then the report region must refresh too which will display the refreshed data.
I currently call the procedure in a Before Header Process, which generates the data for the table used in the report :
I have added the following code to the Report Region Footer. (I found the code at Oracle APEX report refresh the easy way « Warp11 .::. Oracle Apex Knowledge Group )
<script type="text/javascript">
<!--
setInterval("jQuery('##REGION_ID#').trigger('apexrefresh');", 5000);
//-->
</script>
How would I manage to execute the procedure after every 5 seconds or so.? I can only really see if the above code works once the procedure call is being repeated after an interval, so I am not even sure if I am on the right track or not.
I will appreciate any assistance
Regards
Dominic