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