19.3 End-User Context Views

These views help you validate end-user context definitions.

Summary of views

View or Object Name Description
DBA_END_USER_CONTEXT_DEFINITIONS Displays all end-user contexts defined in the database.
ALL_END_USER_CONTEXT_DEFINITIONS Displays all end-user contexts that are accessible to the current user.
USER_END_USER_CONTEXT_DEFINITIONS Displays all end-user contexts owned by the current user.

19.3.1 DBA_END_USER_CONTEXT_DEFINITIONS

Displays all end-user contexts defined in the database. Each context can define a JSON schema and an associated handler procedure for dynamic attribute resolution.

Column Datatype NULL Description

CONTEXT_OWNER

VARCHAR2(128)

NOT NULL

Owner of the end-user context

CONTEXT_NAME

VARCHAR2(128)

NOT NULL

Name of the end-user context

HANDLER_OWNER

VARCHAR2(128)

Schema of the context-handler procedure

HANDLER_PACKAGE

VARCHAR2(128)

Package containing the context-handler procedure

HANDLER_PROCEDURE

VARCHAR2(128)

Name of the context-handler procedure

HANDLER_STATUS

VARCHAR2(7)

Indicates whether the context-handler procedure is VALID or INVALID

JSON_SCHEMA

JSON

Schema definition for the JSON payload

19.3.2 ALL_END_USER_CONTEXT_DEFINITIONS

Displays all end-user contexts that are accessible to the current user.

Column Datatype NULL Description

CONTEXT_OWNER

VARCHAR2(128)

NOT NULL

Owner of the end-user context

CONTEXT_NAME

VARCHAR2(128)

NOT NULL

Name of the end-user context

HANDLER_OWNER

VARCHAR2(128)

Schema of the context-handler procedure

HANDLER_PACKAGE

VARCHAR2(128)

Package containing the context-handler procedure

HANDLER_PROCEDURE

VARCHAR2(128)

Name of the context-handler procedure

HANDLER_STATUS

VARCHAR2(7)

Indicates whether the context-handler procedure is VALID or INVALID

JSON_SCHEMA

JSON

Schema definition for the JSON payload

19.3.3 USER_END_USER_CONTEXT_DEFINITIONS

Displays all end-user contexts owned by the current user.

Column Datatype NULL Description

CONTEXT_NAME

VARCHAR2(128)

NOT NULL

Name of the end-user context

HANDLER_OWNER

VARCHAR2(128)

Schema of the context-handler procedure

HANDLER_PACKAGE

VARCHAR2(128)

Package containing the context-handler procedure

HANDLER_PROCEDURE

VARCHAR2(128)

Name of the context-handler procedure

HANDLER_STATUS

VARCHAR2(7)

Indicates whether the context-handler procedure is VALID or INVALID

JSON_SCHEMA

JSON

Schema definition for the JSON payload