22.17 GET Functions

This function retrieves column values for different data types.

Syntax

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

Signature 1

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

Signature 2

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

Signature 3

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

Signature 4

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

Signature 5

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

Signature 6

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

Signature 7

FUNCTION GET_BLOB (
    p_context    IN t_context,
    p_column_idx IN PLS_INTEGER ) RETURN BLOB;
	
FUNCTION GET_BLOB (
    p_context     IN t_context,
    p_column_name IN VARCHAR2 ) RETURN BLOB;

Signature 8

FUNCTION GET_INTERVALD2S (
    p_context    IN t_context,
    p_column_idx IN PLS_INTEGER ) RETURN DSINTERVAL_UNCONSTRAINED;
	
FUNCTION GET_INTERVALD2S (
    p_context     IN t_context,
    p_column_name IN VARCHAR2 ) RETURN DSINTERVAL_UNCONSTRAINED;

Signature 9

FUNCTION GET_INTERVALY2M (
    p_context    IN t_context,
    p_column_idx IN PLS_INTEGER ) RETURN YMINTERVAL_UNCONSTRAINED;
	
FUNCTION GET_INTERVALY2M (
    p_context     IN t_context,
    p_column_name IN VARCHAR2 ) RETURN YMINTERVAL_UNCONSTRAINED;

Signature 10

FUNCTION GET_ANYDATA (
    p_context    IN t_context,
    p_column_idx IN PLS_INTEGER ) RETURN SYS.ANYDATA;
	
FUNCTION GET_ANYDATA (
    p_context     IN t_context,
    p_column_name IN VARCHAR2 ) RETURN SYS.ANYDATA;

Signature 11

FUNCTION GET_SDO_GEOMETRY (
    p_context     IN t_context,
    p_column_name IN VARCHAR2 ) RETURN MDSYS.SDO_GEOMETRY;

Note:

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

Parameters

Table 22-15 GET Functions Parameters

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

Returns

The column value as specific data type.