WRITE_DATA

The WRITE_DATA procedure is used to send the text content of an email and can be called multiple times to append data to the email.

Syntax

UTL_SMTP.WRITE_DATA (
   c     IN OUT NOCOPY connection,
   data  IN VARCHAR2 CHARACTER SET ANY_CS);

Parameters

Considerations

• OPEN_DATA, WRITE_DATA, WRITE_RAW_DATA, and CLOSE_DATA must be called in strict sequence. open_data sends the data command to declare the start of sending email content. After that, you can call write_data and write_raw_data multiple times to send the email body, and finally call close_data to send the terminator and end the sending.
• The application must ensure that the text content complies with the MIME (RFC822) specification. Use <CR><LF>.<CR><LF> as the message terminator. The <CR><LF>.<CR><LF> in the text content will be translated to <CR><LF>..<CR><LF>.
• Text (varchar2) data will be converted to the US7ASCII character set before being sent. If the text contains multi-byte characters, each multi-byte character that cannot be represented in the US7ASCII character set will be converted to the ? character.
• If the ehlo command and the smtp server negotiate the 8BITMIME extension, you can use the utl_raw package to convert the text to raw data and then send it using write_raw_data.