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

Parameters

Table 15-18 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