DBE_SESSION

Interface Description

Table 1 provides all interfaces supported by the DBE_SESSION package. DBE_SESSION takes effect at the session level.

**Table 1** DBE_SESSION
Interface	Description
DBE_SESSION.SET_CONTEXT	Sets the value of an attribute in a specified context.
DBE_SESSION.CLEAR_CONTEXT	Clears the value of an attribute in a specified context.
DBE_SESSION.SEARCH_CONTEXT	Queries the value of an attribute in a specified context.

DBE_SESSION.SET_CONTEXT

Sets the value of an attribute in a specified namespace (context). The DBE_SESSION.SET_CONTEXT function prototype is as follows:

   
        DBE_SESSION.SET_CONTEXT(
    namespace text,
    attribute text,
    value text
)returns void;

**Table 2** DBE_SESSION.SET_CONTEXT interface parameters
Parameter	Description
namespace	Name of the context to be set. If the context does not exist, create a context. The value contains a maximum of 128 characters.
attribute	Attribute name. The value contains a maximum of 128 characters.
value	Name of the value to be set. The value contains a maximum of 128 characters.

DBE_SESSION.CLEAR_CONTEXT

Clears the value of an attribute in a specified namespace (context). The DBE_SESSION.CLEAR_CONTEXT function prototype is as follows:

   
        DBE_SESSION.CLEAR_CONTEXT (
    namespace text,
    client_identifier text default 'null',
    attribute text
)returns void ;

**Table 3** DBE_SESSION.CLEAR_CONTEXT interface parameters
Parameter	Description
namespace	User-specified context.
client_identifier	Client authentication. The default value is null. Generally, you do not need to manually set this parameter.
attribute	Attribute to be cleared.

DBE_SESSION.SEARCH_CONTEXT

Queries the value of an attribute in a specified namespace (context). The DBE_SESSION.SEARCH_CONTEXT function prototype is:

   
        DBE_SESSION.SEARCH_CONTEXT (
    namespace text,
    attribute text
)returns text;

**Table 4** DBE_SESSION.SEARCH_CONTEXT interface parameters
Parameter	Description
namespace	User-specified context.
attribute	Attribute to be queried.

Example

    
         BEGIN
    select DBE_SESSION.set_context('test', 'gaussdb', 'one');   -- Set the gaussdb attribute of the test context to one.
    select DBE_SESSION.search_context('test', 'gaussdb');
    select DBE_SESSION.clear_context('test', 'test','gaussdb');
END;
/