15.37 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
procedure set_null(
p_context in t_context,
p_column_position in pls_integer );
Signature 2
procedure set_null(
p_context in t_context,
p_column_name in varchar2 );
Parameters
Table 15-35 SET_NULL Procedure Parameters
Parameter | Description |
---|---|
|
Context object obtained with one of the OPEN_ functions. |
|
Position of the column to set the value for within the DML context. |
|
Name of the column to set the value. |
Examples
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