The IN_CONTEXT_SET stored procedure is used to set the value for any of the supported attributes for the specified identifier of the IN_CONTEXT namespace. The list of supported attributes is aligned with the fields of the IN_CONTEXT_ATTR record type.
| Parameter | Description | |
|---|---|---|
| ATTRIBUTE_NAME | Type: | INPUT |
| Datatype: | VARCHAR2(128) | |
| Default Value: | None | |
| Description | The name of the attribute being set for the identifier. | |
| Options |
Reference the IN_CONTEXT_ATTR record type for options. |
|
| ATTRIBUTE_VALUE | Type: | OUTPUT |
| Datatype: | VARCHAR2(257) | |
| Default Value: | NONE | |
| Description: | The value of the attribute being set for the identifier. | |
| Options |
Reference the IN_CONTEXT_ATTR record type for options. |
|
| 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
- FAILED_CHECK – INVALID_IDENTIFIER
- INVALID_NUMBER – Non-Numeric value specified for MAX_MINUTES.
- OTHERS
Examples
IN_DB_UTIL.IN_CONTEXT_SET(ATTRIBUTE_NAME, ATTRIBUTE_VALUE, IDENTIFIER);
IN_DB_UTIL.IN_CONTEXT_SET('STATUS', 'EXECUTING', IDENTIFIER);
IN_DB_UTIL.IN_CONTEXT_SET('START_TIME', SYSTIMESTAMP, IDENTIFIER);
IN_DB_UTIL.IN_CONTEXT_SET('MAX_MINUTES', 60, IDENTIFIER);
IN_DB_UTIL.IN_CONTEXT_SET('OPERATION', 'CREATE_INDEXES', IDENTIFIER);
IN_DB_UTIL.IN_CONTEXT_SET('OBJECT', 'IN_DOC', IDENTIFIER);
IN_DB_UTIL.IN_CONTEXT_SET('SUBOBJECT', 'DOC_IDX2', IDENTIFIER);
IN_DB_UTIL.IN_CONTEXT_SET('TABLESPACE', 'INDX', IDENTIFIER);