Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » System procedures

 

MAPI and SMTP system procedures

SQL Anywhere includes system procedures for sending electronic mail using the Microsoft Messaging API standard (MAPI) or the Internet standard Simple Mail Transfer Protocol (SMTP). These system procedures are implemented as extended system procedures: each procedure calls a function in an external DLL.

These procedures are owned by the dbo role. Users must be granted the EXECUTE privilege on these system procedures before they can use them.

To use the MAPI or SMTP system procedures, a MAPI or SMTP email system must be accessible from the database server computer.

The MAPI and SMTP system procedures are:

  • xp_startmail   Starts a mail session in a specified mail account by logging on to the MAPI message system.

  • xp_startsmtp   Starts a mail session in a specified mail account by logging on to the SMTP message system.

  • xp_sendmail   Sends a mail message to specified users.

  • xp_stopmail   Closes the MAPI mail session.

  • xp_stopsmtp   Closes the SMTP mail session.

  • xp_get_mail_error_code   Returns information about the most recent SMTP or MAPI error.

  • xp_get_mail_error_text   Returns the text of the most recent SMTP error.

 Return codes for MAPI and SMTP system procedures
 Example
 See also