Help Center> GaussDB> Distributed_2.x> Stored Procedures> Advanced Packages> Secondary Encapsulation Interfaces (Recommended)> DBE_SESSION
Updated on 2023-10-23 GMT+08:00
View PDF

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:

1
2
3
4
5
 
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:

1
2
3
4
5
 
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:

1
2
3
4
 
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

1
2
3
4
5
6
 
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;
/