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

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.

This is currently on the roadmap for a future release of Oracle APEX.

Comments

Comments

  • mike_kutz OP 2.5 years ago

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

  • kumo70 OP 1.9 years ago

    Hi,

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

    thanks.

  • karel ekema OP 10 months ago

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