APEX

Hi,

I need to loop through selected rows in an Interactive Grid and with these rows do some processing actions (call a plsql procedure). I found something like this in the link bellow, but here I’m having a conversion error:

ORA-06502: PL/SQL: numeric or value error.

I supposed that's from the conversion:
l_empno := TO_NUMBER(apex_json.get_varchar2(p_path => 'rows[%d].empNo', p0 => i, p_values => l_values));

https://srihariravva.blogspot.com/2019/02/interactive-grid-bulk-operation.html

Do you have any idea how to achieve this? Any other solutions?

Thanks,

Adelina.