SET_NULL Procedure

27.67 SET_NULL Procedure

This procedure sets procedures to set a DML column value to NULL. Useful when the row is initialized from a query context with set_values and the new value of one of the columns should be NULL.

Syntax

Signature 1

APEX_EXEC.SET_NULL (
    p_context               IN t_context,
    p_column_position       IN PLS_INTEGER )

Signature 2

APEX_EXEC.SET_NULL (
    p_context               IN t_context,
    p_column_name           IN VARCHAR2 )

Parameters

Parameter	Description
`p_context`	Context object obtained with one of the `OPEN_` functions.
`p_column_position`	Position of the column to set the value for within the DML context.
`p_column_name`	Name of the column to set the value.

Example 1

apex_exec.set_null(
     p_context         => l_dml_context,
     p_column_position => 6 );

Example 2

apex_exec.set_null(
     p_context         => l_dml_context,
     p_column_name     => 'SAL' );

Parent topic: APEX_EXEC