LetterAddBLOBs

sql

FUNCTION LetterAddBLOBs(IN letter HANDLE, INOUT fname CHAR (255), INOUT table CHAR (63), INOUT attr CHAR (31), INOUT cond CHAR (4090)) RETURNS INT;

Parameters

letter letter handle
fname name of the BLOB (CLOB) letter attachment
table name of the table that will be used for sending (generally anything that can be in the SELECT clause after the FROM keyword)
attr name of the column that will be used for sending (a variable-length column of the CLOB or BLOB type)
cond select condition that identifies the record that will be used for sending (the condition must select exactly one record, otherwise the 21000 exception (SQ_CARDINALITY_VIOLATION) will be raised)

Since version

7.0d

Description

The function attaches a file created from the contents of the BLOB (CLOB) type column of a database table to the created electronic mail letter. The letter handle is returned by the LetterCreate function.

The BLOB type column selection is done in a way which can be used in the SQL language in this function (unlike the similar LetterAddBOLBr which is better for the client language API)

Function value

This function returns 0 if successful, the error number otherwise.

See