In Apex, I have a Interactive grid which displays data from a view. The data is not modified in the grid but needs to be saved to another table when we click on the save button in the interactive grid. I am new to Apex and am unable to save the data to the table. Currently I have created an process with type as “Interactive grid automatic row processing” target type as Table and the table name provided.
Share
Delete the IG automatic row processing and create a custom PL/SQL code processing something like below:
In the above code, change the cursor query to the same as your interactive grid query.
Your interactive grid is based on the view and not editable, so you can use the query in cursor you used for the interactive grid.
Also, the Save button in the interactive grid will not work this.
Create another button and set the action type to Submit and on submit the above process will execute. But make sure that the above process should be written above the close dialog process if exists.
Let me know if any further questions.