22.47 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 );

Signature 11

Note:

This signature is only available if SDO_GEOMETRY (Oracle Locator) is installed in the database.

PROCEDURE SET_VALUE(
    p_context               IN t_context,
    p_column_position       IN PLS_INTEGER,
    p_value                 IN mdsys.sdo_geometry );

PROCEDURE SET_VALUE(
    p_context               IN t_context,
    p_column_name           IN VARCHAR2,
    p_value                 IN mdsys.sdo_geometry );

Parameters

Table 22-45 SET_VALUE Procedure 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 for.
p_value	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 ) );