Sends the VRFY command to verify the validity of the target email address.
Applicability
This topic applies only to OceanBase Database in Oracle mode.
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 response to the command. If multiple responses are returned, only the last one 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 fully qualified email path.
- This command must be called after
open_connectionandheloorehlo. - The expected return value is a response starting with
250or251.250: The SMTP server returns this code if it successfully processes the VRFY (verify) request and confirms that the queried email address is valid. This means the email address exists and can receive emails.251: This code may be returned if the email address to be verified is not local but the server knows how to forward it to the correct destination.