I'm, using Oracle APEX 4.2. In one of my pages i have two regions. One of them has a text field and a button, and the another region with a tabular form.
I want to enter some data into the text field and when I press the Button named Estado, just the rows checked change the value of the column Estado.
Please may you review the workspace again. I'm getting a problem. When the first Pago_id isn't 1 the Pago_estado column doesn't update.
The procedure is not getting the value of the column Pago_id.
new password: Abc123*
Edited by: Eve on 05/02/2013 01:16 PM
I already solved the issue, I added the value of the Pago Id column.
for i in 1..apex_application.g_f01.count loop
vRow := apex_application.g_f01(i);
set PAGO_ESTADO = :P2_VALOR
where PAGO_ID = apex_application.g_f02(vRow);