Skip to content

docs: add DBMS_SESSION package documentation #411

Open

Description

@1794851403

Summary

DBMS_SESSION (the application-context subset implemented in contrib/ivorysql_ora) has no documentation page in either the English or the Chinese documentation, and no navigation entry.

The implemented interfaces are:

  • DBMS_SESSION.SET_CONTEXT(namespace, attribute, value)
  • DBMS_SESSION.CLEAR_CONTEXT(namespace [, attribute])
  • DBMS_SESSION.CLEAR_ALL_CONTEXT(namespace)
  • DBMS_SESSION.RESET_PACKAGE
  • sys.dbms_session_list_context()

The package is covered by the regression test contrib/ivorysql_ora/sql/dbms_session.sql and integrates with SYS_CONTEXT and row-level security, but none of this is described in the documentation center.

Proposed change

Add bilingual pages:

  • EN/modules/ROOT/pages/master/oracle_compatibility/compat_dbms_session.adoc
  • CN/modules/ROOT/pages/master/oracle_compatibility/compat_dbms_session.adoc

and register them in both nav.adoc files under Oracle Compatibility.

The pages cover the supported interfaces, name/value limits, SYS_CONTEXT read-back, case-insensitivity, LIST_CONTEXT, row-level security, RESET_PACKAGE, and connection-pool cleanup. All examples and outputs are taken from / checked against the regression test.

Verification

  • Interfaces and limits: contrib/ivorysql_ora/src/builtin_packages/dbms_session/dbms_session.c and dbms_session--1.0.sql.
  • Expected results: contrib/ivorysql_ora/expected/dbms_session.out.
  • AsciiDoc pages pass asciidoctor with no warnings.

Activity

  1. 1794851403 commented on Nov 15, 2026

    @1794851403
    Author

    /assign

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions