ora-lob-create-empty Function

Summary

Creates an empty LOB.

Package

sql

Signature

ora-lob-create-empty &key db type => lob-locator

Arguments

db⇩	A database.
type⇩	A Lisp object.

Values

lob-locator

A LOB locator.

Description

The function ora-lob-create-empty creates an empty LOB object and returns a LOB locator for it.

If type is :lob then ora-lob-create-empty creates a LOB of type BLOB/CLOB. If type is any other value, it creates a file LOB. The default value of type is :lob.

Empty LOBs can be put in the database by passing them to insert-records or update-records. However, the preferred approach is to use the Oracle SQL function EMPTY_BLOB as described in the section 23.11.1.3 Inserting empty LOBs.

The default value of db is the value of *default-database*.

Notes

ora-lob-create-empty is available only when the "oracle" module is loaded. See the section 23.11 Oracle LOB interface for more information.