Instead you can do this
Create a hidden item to set your input parameter :P1_INPUT
Creata a report.
Go to report attributes you want to kick of ur procedure
Navigate to column link,
Lets say report is on page 1.
Page in this application 1
set value to the hidden item.
Onload before header write a process,
Have it conditional
:P1_INPUT NOT NULL
:P1_INPUT := NULL;
Assuming the parameter passed to the procedure comes from the report row, you can do this...
- Create a hidden item (P1_PARAM1)
- create a new standard column in the report like this..
4. Create a dynamic action to execute the pl/sql procedure passing P1_PARAM1 using id ID4DA as a jquery selector to trigger the DA.
Hope it was clear.