Release 3.00
Oct 14, 2002
|
Sybernet / Supplied Procedures Reference
Release 3.00 Oct 14, 2002 |
|
This procedure provides a convenient interface for sending a simple e-mail message from your stored procedure or PL/SQL block. The mail is sent asychronously using Sybercron and does not affect the flow or execution time of your routine.
Procedure SP_SENDMAIL
(
SUBJECT VARCHAR2
, MAILTO VARCHAR2
, MAILCC VARCHAR2
, MAILBCC VARCHAR2
, MAILFROM VARCHAR2
, PRIORITY VARCHAR2
, MESSAGE VARCHAR2
, CONTENTTYPE VARCHAR2
, TIMESTAMP DATE
, COMPOSING VARCHAR2
, PLATFORM VARCHAR2
) ;
| Parameter | Description |
|---|---|
subject |
The subject or title of this message. |
mailto |
The e-mail address of the recepient. |
mailcc |
The e-mail address for sending a carbon-copy. |
mailbcc |
The e-mail address for sending a blank carbon-copy. |
mailfrom |
Your e-mail address. |
priority |
This parameter can be one of
The default is 3 (normal) |
message |
This contains the body of your e-mail. Since this message is written to the CRON table, the largest possible message is 4,000 characters. If you need to send a larger message than this, you will have to write your own routine. |
contenttype |
This parameter should be one of
The default is text/plain. |
timestamp |
Specifies when this mail is to be sent. If you want the mail to be sent immediately, omit completely or specify NULL. |
composing |
For Internal Use Only. |
platform |
The platform (or identity value) where Sybercron is running. This can be left unspecified because the default platform should be able to send this mail. |
The following example illustrates how to call sp_sendmail:
HTTP.SP_SENDMAIL
(
SUBJECT => 'Test Message'
, MAILTO => 'nospam@nospams.com'
, MAILFROM => 'nospam@nospams.com'
, MESSAGE => 'Hello World'
, CONTENTTYPE => 'text/plain'
) ;