Get_Context_Parameter

Returns a named context parameter value. This is an overloaded function that returns a String, Number, Date or Boolean value. The PL/SQL cannot distinguish the overloaded functions from each other on the return type. The default value has to be of the correct type to avoid a compile time error. Use TO_CHAR(NULL), TO_NUMBER(NULL) or TO_DATE(NULL) to pass NULLS as default values or use a variable of the correct data type.

FUNCTION Get_Context_Parameter (
   name_           IN type_name_,
   default_value_  IN VARCHAR2 DEFAULT NULL ) RETURN VARCHAR2

FUNCTION Get_Context_Parameter (
   name_           IN type_name_,
   default_value_  IN NUMBER   DEFAULT NULL ) RETURN NUMBER

FUNCTION Get_Context_Parameter (
   name_           IN type_name_,
   default_value_  IN DATE     DEFAULT NULL ) RETURN DATE

FUNCTION Get_Context_Parameter (
   name_           IN type_name_,
   default_value_  IN BOOLEAN  DEFAULT NULL ) RETURN BOOLEAN

Parameters

name_
    Context parameter name.

default_value_
    Return value if context parameters is not found.

Return value

    Context parameter value.