Couple of options that might work--
Leave 1) Submit Page
Remove 2) and 3)
Place the PL/SQL Code in a page process conditional on the request set in 1) Submit Page
The report will reload when the page is rendered again.
Remove 1) Submit Page [ why are you submitting the page? ]
Leave 2) and 3)
Thanks for the solution. I have tried the first method. It is working fine.
But as we have written the PL/SQL code in page process ( Before Header), the page is taking time as it is executing the PL/SQL code.
Is any other way to perform the same action only after clicking the button.