The IN_CONTEXT_GET function is used to fetch the current attribute values for the specified identifier of the IN_CONTEXT namespace. The list of supported attributes align with the fields of the IN_CONTEXT_ATTR record type.
| Parameter | Description | |
|---|---|---|
| IDENTIFIER | Type: | OUTPUT |
| Datatype | VARCHAR2(128) | |
| Default Value: | IN_DB_UTIL | |
| Description | The identifier of the IN_CONTEXT namespace. | |
| Options |
IN_DB_UTIL SYNC UPGRADE |
|
Exceptions
Examples
SELECT * FROM TABLE(IN_DB_UTIL.IN_CONTEXT_GET('SYNC'));
SELECT * FROM TABLE(IN_DB_UTIL.IN_CONTEXT_GET('UPGRADE'));
SELECT * FROM TABLE(IN_DB_UTIL.IN_CONTEXT_GET('IN_DB_UTIL'));
SELECT STATUS, MAX_TIME FROM TABLE(IN_DB_UTIL.IN_CONTEXT_GET('IN_DB_UTIL'));
SELECT DB_SESSION FROM TABLE(IN_DB_UTIL.IN_CONTEXT_GET('IN_DB_UTIL'));