Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_LOB , 14 of 26
This procedure frees the temporary BLOB
or CLOB
in your default temporary tablespace. After the call to FREETEMPORARY
, the LOB
locator that was freed is marked as invalid.
If an invalid LOB
locator is assigned to another LOB
locator using OCILobLocatorAssign
in OCI or through an assignment operation in PL/SQL, then the target of the assignment is also freed and marked as invalid.
DBMS_LOB.FREETEMPORARY ( lob_loc IN OUT NOCOPY BLOB); DBMS_LOB.FREETEMPORARY ( lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS);
Parameter | Description |
---|---|
lob_loc |
|
DECLARE a blob; b blob; BEGIN dbms_lob.createtemporary(a, TRUE); dbms_lob.createtemporary(b, TRUE); ... -- the following call frees lob a dbms_lob.freetemporary(a); -- at this point lob locator a is marked as invalid -- the following assignment frees the lob b and marks it as invalid also b := a; END;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|