This content has been marked as final. Show 8 replies
Please provide a developer account on the workspace to solve it for you.
The workspace is COSITASLINDAS_2
The applications is CARGARESTADO
I have made a PL/SQL process called updatePAGObyEstado executed when the button pressed, with the following code
Please, if this solves your problem, mark it as Correct.
BEGIN for i in 1..apex_application.g_f01.count loop update PAGO set PAGO_ESTADO = :P2_VALOR where PAGO_ID = apex_application.g_f01(i); end loop; COMMIT; END;
You help me a lot!!
Welcome any time :)1 person found this helpful
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);
Glad because it is working :)