DB2 Version 9.7 for Linux, UNIX, and Windows

VRFY procedure - Validate and verify the recipient's email address

The VRFY function provides the capability to validate and verify a recipient email address. If valid, the recipient's full name and fully qualified mailbox is returned.

Syntax


>>-UTL_SMTP.VRFY--(--c--,--recipient--,--reply--)--------------><

Parameters

c: An input or output argument of type CONNECTION that specifies the SMTP connection on which to verify the email address.
recipient: An input argument of type VARCHAR(256) that specifies the email address to be verified.
reply: An 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.