GET_PARAMETER Functions
These functions returns a SQL parameter value. Typically used to retrieve values for OUT
binds of an executed SQL or PL/SQL statement.
Syntax
function get_parameter_varchar2(
p_parameters in t_parameters,
p_name in varchar2 ) return varchar2;
function get_parameter_number(
p_parameters in t_parameters,
p_name in varchar2 ) return number;
function get_parameter_date(
p_parameters in t_parameters,
p_name in varchar2 ) return date;
function get_parameter_timestamp(
p_parameters in t_parameters,
p_name in varchar2 ) return timestamp;
function get_parameter_timestamp_tz(
p_parameters in t_parameters,
p_name in varchar2 ) return timestamp with time zone;
function get_parameter_timestamp_ltz(
p_parameters in t_parameters,
p_name in varchar2 ) return timestamp with local time zone;
function get_parameter_clob(
p_parameters in t_parameters,
p_name in varchar2 ) return clob;
function get_parameter_interval_d2s(
p_parameters in t_parameters,
p_name in varchar2 ) return interval day to second;
function get_parameter_interval_y2m(
p_parameters in t_parameters,
p_name in varchar2 ) return interval year to month;
Parameters
Table 14-13 GET_PARAMETER Function Parameters
Parameter | Description |
---|---|
|
SQL parameter array. |
|
Parameter name. |
Returns
Parameter value
Parent topic: APEX_EXEC