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

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 23.11 Oracle LOB interface for more information.

LispWorks® User Guide and Reference Manual - 01 Dec 2021 19:30:56