Function

Summary

Creates a temporary LOB.

Package

sql

Signature

ora-lob-create-temporary db-or-lob-locator &key errorp cache session-duration clob-p => lob-locator

Arguments

db-or-lob-locator

A database or a LOB locator.

errorp

A generalized boolean.

cache

A generalized boolean.

session-duration

A generalized boolean.

clob-p

A generalized boolean.

Values

lob-locator

A LOB locator.

Description

The function ora-lob-create-temporary creates a temporary LOB.

db-or-lob-locator specifies the database to associate the new LOB with. If it is a LOB locator the database from which the LOB locator came is used.

If an error occurs and errorp is true, an error is signaled. If errorp is false, the function returns an object of type sql-database-error. The default value of errorp is nil .

cache specifies whether to use a cache or not. The default value of cache is nil .

session-duration specifies the lifetime: if it is true then it uses OCI_DURATION_SESSION, otherwise it uses OCI_DURATION_CALL. The default value of session-duration is t .

If clob-p is true then the new LOB is a CLOB, otherwise it is a BLOB. The default value of clob-p is nil .

The new temporary LOB locator is returned.

Note: This is a direct call to OCILobCreateTemporary.

Note: this function is available only when the "oracle" module is loaded. See the section on the Oracle LOB interface in the LispWorks User Guide for more information.

See also

ora-lob-free-temporary
ora-lob-is-temporary