16.23 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 16-21 GET_PARAMETER Function Parameters
Parameter | Description |
---|---|
|
SQL parameter array. |
|
Parameter name. |
Returns
Parameter value
Parent topic: APEX_EXEC