Skip to Main Content
Feature Request FR-2075
Product Area Page Components
Status CLOSED

32 Voters

Process type to execute PL/SQL code before & after IG DML save (Only once. Not row-by-row)

toufiqmohmd Public · Oct 15 2021

Idea Summary
Process type to execute PL/SQL code before & after IG DML save. This PL/SQL block should be executed only once per Grid DML call. Not row-by-row.

Something like this may help.

Use Case
For example, update master table status if all child table records are marked as closed, for calculating totals etc. Having to do this row-by-row is too expensive.

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • mike_kutz OP 3.2 years ago

    I would imagine that the Bulk DML function would need to have in apex_application_global.vc_arr2 parameters.

  • kumo70 OP 2.5 years ago

    Hi,

    iam faced with this same issue - did you get the answer?

    thanks.

  • karel ekema OP 1.5 years ago

    @toufiqmohmd : how will this process type (before/after save) be different from ‘Execute Code’?