15.38 SET_VALUE Procedure
This procedure sets DML column values for different data types. To be called after add_dml_row
for each column value to be set. Each procedure is called either with the column name or with the column position.
Syntax
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_position IN PLS_INTEGER,
p_value IN VARCHAR2 );
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_name IN VARCHAR2,
p_value IN VARCHAR2 );
Signature 1
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_position IN PLS_INTEGER,
p_value IN NUMBER );
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_name IN VARCHAR2,
p_value IN NUMBER );
Signature 2
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_position IN PLS_INTEGER,
p_value IN DATE );
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_name IN VARCHAR2,
p_value IN DATE );
Signature 3
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_position IN PLS_INTEGER,
p_value IN TIMESTAMP );
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_name IN VARCHAR2,
p_value IN TIMESTAMP );
Signature 4
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_position IN PLS_INTEGER,
p_value IN TIMESTAMP WITH TIME ZONE);
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_name IN VARCHAR2,
p_value IN TIMESTAMP WITH TIME ZONE);
Signature 5
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_position IN PLS_INTEGER,
p_value IN TIMESTAMP WITH LOCAL TIME ZONE);
procedure set_value(
p_context in t_context,
p_column_name in varchar2,
p_value in timestamp with local time zone);
Signature 6
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_position IN PLS_INTEGER,
p_value IN DSINTERVAL_UNCONSTRAINED );
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_name IN VARCHAR2,
p_value IN DSINTERVAL_UNCONSTRAINED );
Signature 7
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_position IN PLS_INTEGER,
p_value IN YMINTERVAL_UNCONSTRAINED );
PROCEDURE SET_VALUE(
p_context in t_context,
p_column_name IN VARCHAR2,
p_value IN YMINTERVAL_UNCONSTRAINED );
Signature 8
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_position IN PLS_INTEGER,
p_value IN CLOB );
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_name IN VARCHAR2,
p_value IN CLOB );
Signature 9
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_position IN PLS_INTEGER,
p_value IN BLOB );
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_name IN VARCHAR2,
p_value IN BLOB );
Signature 10
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_position IN PLS_INTEGER,
p_value IN SYS.ANYDATA );
PROCEDURE SET_VALUE(
p_context IN t_context,
p_column_name IN VARCHAR2,
p_value IN SYS.ANYDATA );
Parameters
Table 15-36 SET_VALUE 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 for. |
|
Value to set. |
Example
apex_exec.set_value(
p_context => l_dml_context,
p_column_name => 'SAL',
p_value => 9500 );
apex_exec.set_value(
p_context => l_dml_context,
p_column_position => 6,
p_value => 9500 );
apex_exec.set_value(
p_context => l_dml_context,
p_column_position => 'HIREDATE',
p_value => trunc( sysdate ) );
Parent topic: APEX_EXEC