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 "Inserting empty LOBs" in the LispWorks User Guide .

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

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.