The CREATETEMPORARY stored procedure creates a temporary BLOB or CLOB and the corresponding index in the default temporary tablespace.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_LOB.CREATETEMPORARY (
lob_loc IN OUT NOCOPY BLOB,
cache IN BOOLEAN,
dur IN PLS_INTEGER := 10);
DBMS_LOB.CREATETEMPORARY (
lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
cache IN BOOLEAN,
dur IN PLS_INTEGER := 10);
Parameters
| Parameter | Description |
|---|---|
| lob_loc | The locator of the LOB. For more information, see Considerations. |
| cache | Specifies whether to read the LOB into the buffer cache. |
| dur | One of two predefined duration values (SESSION or CALL), which specifies a hint as to whether the temporary LOB is cleared at the end of the session or call. If dur is omitted, the session duration is used. |