Set_Context_Parameter¶
Sets a named context parameter value. If the context parameter already exists the value is changed to the new value otherwise the context parameter is added. This is an overloaded procedure that takes a String, Number, Date or Boolean value as the context parameter value. The length of a string value is limited to 2000 characters. If a context parameter with the value NULL should be added the NULL 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 add context parameters with the value NULL or use a variable of the correct data type.
PROCEDURE Set_Context_Parameter (
name_ IN type_name_,
value_ IN VARCHAR2,
typ_ IN type_type_ DEFAULT 'S',
status_ IN type_status_ DEFAULT NULL )
PROCEDURE Set_Context_Parameter (
name_ IN type_name_,
value_ IN NUMBER,
typ_ IN type_type_ DEFAULT 'N',
status_ IN type_status_ DEFAULT NULL )
PROCEDURE Set_Context_Parameter (
name_ IN type_name_,
value_ IN DATE,
typ_ IN type_type_ DEFAULT 'D',
status_ IN type_status_ DEFAULT NULL )
PROCEDURE Set_Context_Parameter (
name_ IN type_name_,
value_ IN BOOLEAN,
typ_ IN type_type_ DEFAULT 'B',
status_ IN type_status_ DEFAULT NULL )
Parameters¶
name_
Context parameter name.
value_
Context parameter value.
typ_
Context parameter data type.
status_
Context parameter status.