CreateTempBLOB and CreateTempCLOB Methods

Example

Applies To

OraDatabase

Description

Creates a Temporary LOB in the database.

Arguments

use_caching

Specifies whether Oracle uses caching when accessing this LOB. The default value is false.

Usage

Set OraBLOB = OraDatabase.CreateTempBLOB(false)

Set OraCLOB = OraDatabase.CreateTempCLOB(false)

Remarks

Temporary LOBs are LOBs which do not exist permanently in the database. OO4O programmers most commonly use them to pass into stored procedures and functions which have LOB arguments.

Temporary LOBs do not require nor take part in transactions. (It is not necessary to acquire a lock prior to writes, and rollbacks have no effect on temporary LOBs.)

The use_caching argument directs Oracle to use caching when accessing the temporary LOB. This is suggested when multiple accesses are expected on a single LOB. Caching is not required for the typical case, where a LOB is created, filled with data, passed to a stored procedure, and then discarded.

Temporary LOBs exists on the server until no more references to the corresponding OraBLOB or OraCLOB exist on the client. Please note that these references include any OraParameter or OraParamArray which contain a temporary OraBLOB or OraCLOB.