Update pivot columns of an Interactive Grid?

britoo95

Hello guys,

I'm developing a page with an IG report that can be updated by the user.

My query is giving me the correct information but the problem is that I want to update the pivot columns (more than one) and I don't how to get the keys to update the right table.

I've noticed the Save interactive grid process has a type target which I can set to PL/SQL and reference the coluns like :COLUMN however I don't know how it helps in my case.

The structure is this:

EMPLOYESS|      |EMPLOYEE_CERTIFICATE|

id_emp          |       |id_cert_emp                         |

name             |       |id_emp                                 |  

                              |date_cert                              |    

                              |id_certificate                         |

I've created an example at oracle apex online:

workspace: PIVOT_REPORT

user: visit

password: visit123

If know of any workarounds it would be very helpful too.

Thanks for your time.