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!

Interactive Grid - castomization "Save" button

Maja FilipowiczNov 10 2023 — edited Nov 10 2023

If I understand correctly, only after selecting the "save" button all operations are performed on the interactive grid, e.g. updating changed data (color: blue), adding a new record to the table and deleting(color: green) a record from the table (color: grey)...


As you can see, the interactive grid knows what actions have been performed - different colors for individual operations.

So, I need to adapt the "save" action to my solution because I want to run a PL/SQL procedure for individual operations (update, add, delete), which create a transaction on the database. - First question: how run and where PL/SQL procedures for each operations? I suspect I'll have to invoke it via JS.

And second question: is there any way to check what operation was performed on the record?
How does the "Save" action deal with this, that it has to do UPDATE, INSERT, DELETE.

Comments
Post Details
Added on Nov 10 2023
1 comment
849 views