Skip to content

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.