ADD_DML_ROW Procedure

26.6 ADD_DML_ROW Procedure

This procedure adds one row to the DML context. This is called after the open_dml_context and before the execute_dml procedures. This procedure can be called multiple times to process multiple rows. All columns of the new row are initialized with NULL.

Use set_value, set_null, and set_row_version_checksum to populate the new row with values and the checksum for lost-update detection.

Syntax

APEX_EXEC.ADD_DML_ROW (
    p_context               IN t_context,
    p_operation             IN t_dml_operation );

Parameters

Parameter	Description
`p_context`	Context object obtained with one of the `OPEN_` functions
`p_operation`	DML operation to be executed on this row. Possible values: `c_dml_operation_insert` `c_dml_operation_update` `c_dml_operation_delete`