Function

Summary

Appends two internal LOBs together.

Package

sql

Signature

ora-lob-append src-lob-locator dest-lob-locator &key errorp

Arguments

src-lob-locator

A LOB locator.

dest-lob-locator

A LOB locator.

errorp

A generalized boolean.

Description

The function ora-lob-append appends the contents of the LOB pointed to by src-lob-locator to the end of LOB pointed by dest-lob-locator . The source and destination LOBs must be of the same internal LOB type, that is, either both BLOB or both CLOB/NCLOB.

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 .

ora-lob-append is applicable to internal LOBs only.

Note: This is a direct call OCILobAppend.

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.