The CREATETEMPORARY stored procedure creates a temporary BLOB or CLOB and the corresponding index in the default temporary tablespace.
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 Usage notes. |
| 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. |