You can create a temporary LOB with
ora-lob-create-temporary
.
You can test whether a LOB is temporary with
ora-lob-is-temporary
.
You can free a temporary LOB locator if necessary with
ora-lob-free-temporary
, though temporary LOB locators are freed automatically when the database connection is closed by
disconnect
.