CLOSE_DATA is used to send a <CR><LF>.<CR><LF> to indicate the completion of email text transmission.
Applicability
This content applies only to the Oracle-compatible mode of OceanBase Database.
Syntax
UTL_SMTP.CLOSE_DATA (
c IN OUT NOCOPY connection)
RETURN reply;
UTL_SMTP.CLOSE_DATA (
c IN OUT NOCOPY connection);
Parameters
| Parameter | Description |
|---|---|
| c | The SMTP connection. |
Return value
| Return value | Description |
|---|---|
| reply | The reply to the command. If multiple replies are received, the last reply is returned. |
Considerations
OPEN_DATA, WRITE_DATA, WRITE_RAW_DATA, and CLOSE_DATA must be called in strict sequence. OPEN_DATA sends the data command to indicate the start of email content transmission. Multiple calls to WRITE_DATA and WRITE_RAW_DATA can then be made to send the email body, and finally, CLOSE_DATA sends the terminator to end the transmission.