VRFY is used to verify the validity of the target email address.
Applicability
This content applies only to the Oracle-compatible mode of OceanBase Database.
Syntax
UTL_SMTP.VRFY (
c IN OUT NOCOPY connection
recipient IN VARCHAR2)
RETURN reply;
Parameters
| Parameter | Description |
|---|---|
| c | The SMTP connection. |
| recipient | The email address to be verified. |
Return value
| Return value | Description |
|---|---|
| reply | The reply to the command. If multiple replies are returned, the last reply is returned. |
Considerations
- The server will attempt to resolve the email address to be verified. If successful, it will return the recipient's full name and the fully qualified mailbox path.
- Must be called after
open_connectionand eitherheloorehlo. - The expected response is a message starting with
250or251.250: This code is returned when the SMTP server successfully processes the VRFY (verify) request and confirms that the queried email address is valid. This indicates that the email address exists and can receive emails.251: This code may be returned if the email address being verified does not belong to the local system, but the server knows how to forward it to the correct destination.