The IN_CONTEXT_CLEAR stored procedure is used to clear the value for any of the supported attributes for the specified IN_CONTEXT namespace identifier. 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 cleared 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 ALL |
|
Exceptions
Examples
IN_DB_UTIL.IN_CONTEXT_CLEAR(ATTRIBUTE_NAME, IDENTIFIER);
IN_DB_UTIL.IN_CONTEXT_CLEAR('STATUS', IDENTIFIER );
IN_DB_UTIL.IN_CONTEXT_CLEAR('OPERATION', IDENTIFIER );
IN_DB_UTIL.IN_CONTEXT_CLEAR('OBJECT', IDENTIFIER );
IN_DB_UTIL.IN_CONTEXT_CLEAR('SUBOBJECT', IDENTIFIER );
IN_DB_UTIL.IN_CONTEXT_CLEAR('ALL', IDENTIFIER );