Can you please elaborate on what the scenario is?
Sounds like you have to use apex.submit or apex.confirm just like AlexAA said.
Thanks for the answers.
let me try to clarify some points.
First of all i have a report with a numeric column.
*If the sum of a column is greater than 100, when the user click in a button i must ask him for continue and later execute the pl/sql
*If the sum is lower, when the user click in a button i just execute the pl/sql code
How can i do that
So you want to execute a Pl-sql code irrespective of the sum? The user is clicking on the same button and the same pl-sql code is being executed? or there are two pl-sql codes which are being executed based on the value of the sum?
Have you found out a way to calculate the sum? If so, can you store the sum in an Item (hidden item may be)? Based on the value in this Item, you can decide what you want to do (which is still pretty unclear to me).
The user is clicking on the same button and the same pl-sql code is being executed?
Yes the same button and the same code.
Have you found out a way to calculate the sum?
yes i already have the value.
I don't want to show a confirm message all the time the user click on the button.
The message must appear only when the value of a hidden item is greater than 100. In this case de user have de option to accept or not the execution.
If the value is lower than 100 there is not need to show a warning. just execute the pl/sql
One option would be:
Set the submit button as defined by dynamic action.
Create a dynamic action on button click
(I expect you'd know how to get the value of the total to use in the above expression)
For true action
1: Confirm action
For false action
It's a very simple solution and exactly what I was looking for.
And thanks everybody for the support