22.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 22-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

Example

See"OPEN_REMOTE_DML_CONTEXT Function","OPEN_WEB_SOURCE_DML_CONTEXT Function (Deprecated)","OPEN_LOCAL_DML_CONTEXT Function"