DB2 Version 9.7 for Linux, UNIX, and Windows

RCPT procedure - Provide the email address of the recipient

The RCPT procedure provides the email address of the recipient.

Note: To schedule multiple recipients, invoke the RCPT procedure multiple times.

Syntax


>>-UTL_SMTP.RCPT--(--c--,--recipient---------------------------->

>--+-------------------------+--)------------------------------><
   '-,--parameters--,--reply-'

Parameters

c: An input or output argument of type CONNECTION that specifies the SMTP connection on which to add a recipient.
recipient: An input argument of type VARCHAR(256) that specifies the email address of the recipient.
parameters: An optional input argument of type VARCHAR(32672) that specifies the mail command parameters in the format key=value.
reply: An optional output argument of type REPLY that returns a single reply line from the SMTP server. It is the last reply line if multiple reply lines are returned by the SMTP server.

Authorization

EXECUTE privilege on the UTL_SMTP module.

Usage notes

This procedure can be invoked using function invocation syntax in a PL/SQL assignment statement.