All Manuals > LispWorks User Guide and Reference Manual > 38 The SQL Package

NextPrevUpTopContentsIndex

ora-lob-append

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.

Notes
  1. ora-lob-append is a direct call OCILobAppend.
  2. ora-lob-append is available only when the "oracle" module is loaded. See the section Oracle LOB interface for more information.

LispWorks User Guide and Reference Manual - 21 Dec 2011

NextPrevUpTopContentsIndex