I would like to have help in the below mentioned issu.
I have created a dynamic action on click of button ->The true actions as follows
1) Submit Page
2) Execute PL/SQL Code - Where am calling a procedure to execute.
3) Refresh report
The report is displaying properly, everything is fine, But the problem here is the report will take some time to display.
The submit page dynamci acton is not running eventhough I have made the sequence as first true action.
Only after executing the PL/SQL code the submit page is working.
But in actual it has to display at the time where it is spending to fetch the report.
I have tried the way which is used in this link p[ http://apex.oracle.com/pls/otn/f?p=11933:69:104064768865375::::: ], but still its not working.
Is there any other way to do this. Kindly help me in this if any know how to show this.
Thanks in Advance. . .
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.