APEX : 23.2.3
Using a process in a form : Automatic Row Processing(DML) to perform insert/update/deletes
I am using before insert trigger on the table that gets the nextval from a sequence and assigns this value to the :new.id field
Within APEX the DML process has an option “Return Primary Key(s) after Insert”
The help for this option mentions “ Generally, this option should be used when the primary key columns are populated from a database trigger or an Oracle Database 12 c Identity column”
My question :
- How to you access the returned primary key on the insert, when this option has been enabled.
- Is the return value store in a variable/item. If so, what is it called ?