18.16 GET Functions

These functions retrieve column values. There is one function for each supported data type.

Syntax

FUNCTION GET_VARCHAR2 (
    p_context     IN t_context,
    p_column_idx  IN PLS_INTEGER ) RETURN VARCHAR2;
    
FUNCTION GET_NUMBER (
    p_context    IN t_context,
    p_column_idx IN PLS_INTEGER ) RETURN NUMBER;

FUNCTION GET_DATE (
    p_context    IN t_context,
    p_column_idx IN PLS_INTEGER ) RETURN DATE;

FUNCTION GET_TIMESTAMP (
    p_context    IN t_context,
    p_column_idx IN PLS_INTEGER ) RETURN TIMESTAMP;

FUNCTION GET_TIMESTAMP_TZ (
    p_context    IN t_context,
    p_column_idx IN PLS_INTEGER ) RETURN TIMESTAMP WITH TIME ZONE;

FUNCTION GET_TIMESTAMP_LTZ (
    p_context    IN t_context,
    p_column_idx IN PLS_INTEGER ) RETURN TIMESTAMP WITH LOCAL TIME ZONE;

FUNCTION GET_CLOB (
    p_context    IN t_context,
    p_column_idx IN PLS_INTEGER ) RETURN CLOB;

FUNCTION GET_INTERVALD2S (
    p_context    IN t_context,
    p_column_idx IN PLS_INTEGER ) RETURN INTERVAL DAY TO SECOND;

FUNCTION GET_INTERVALY2M (
    p_context    IN t_context,
    p_column_idx IN PLS_INTEGER ) RETURN INTERVAL YEAR TO MONTH;

Parameters

Table 18-14 GET Function Parameters

Parameter	Description
p_context	Context object obtained with one of the OPEN_ functions.
p_column_idx	Column index.

Returns

Column value as specific data type.