Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Apex 20.1 Insert, Update, Delete values from one Interactive Grid to another Interactive Grid

hiddenonearthFeb 25 2021

Hi,
on one of my page I a have a Interactive Grid which gets created by selecting a project from a Popup LOV. Based on the selection, different data gets loaded in the IG. In this IG I have pre-filled two columns project_name and project_result.
My goal is to when loading the data in the IG to save the changes into a second table (i.e. Interactive Grid). So that the first IG doesn't get changed with the pre-filled columns or overwritten, and the data with the rows gets loaded in the second table for further processing.
I also have the problem that the pre-filled data from the IG doesn't get saved into the second table.
Any ideas on how to achive this goal?
I already tried it with removing the Interactive Grid Row Processing and custom PL/SQL but the data doesn't get saved or itt says no ROWID found.
Thank you.
Kind regards.

Comments
Post Details
Added on Feb 25 2021
1 comment
1,200 views