1 person found this helpful
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.
Good point, I did this already and it worked.
Sorry for being late,and thank you for your answers.
Please Ramesh P,Create a hidden item to set your input parameter :P1_INPUT is that when i choose to create a form on a stored procedure or what ?
I need more clarifications (I'm still discovering APEX )