24.5 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

PROCEDURE ADD_DML_ROW(
    p_context               IN t_context,
    p_operation             IN t_dml_operation );

Parameters

Table 24-2 ADD_DML_ROW 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