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. |
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 |
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 |
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 |