Skip to content

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 ) RETURN VARCHAR2 FUNCTION Get_Context_Parameter (    name_ IN type_name_, default_value_  IN NUMBER ) RETURN NUMBER FUNCTION Get_Context_Parameter (    name_ IN type_name_, default_value_  IN DATE ) RETURN DATE FUNCTION Get_Context_Parameter (    name_ IN type_name_, default_value_  IN BOOLEAN ) RETURN BOOLEAN

Parameters

name_
Context parameter name.

default_value_
Return value if context parameters is not found.

Return value

Context parameter value.