SMTP: Mail Outgoing Mail Message Queue
insert delete
- Catalog:
Mail - Primary Keys:
id - Label: Outgoing Mail Message Queue
Can retrieve data and change data using insert and delete.
Table Columns
The columns of the table SMTP are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Address |
varchar2 |
Address Encoding | fetched only when named | Character set for encoding mail addresses. | |
Disposition |
varchar2 |
Disposition Notification to Email Address | fetched only when named | Email address in Disposition-Notification-To header. | |
Headers |
varchar2 |
Headers Encoding | fetched only when named | Character set for encoding headers. | |
Return |
varchar2 |
Return Receipt To Email Address | fetched only when named | Email address in Return-Receipt-To header. | |
attachment1 |
blob |
Attachment 1 Contents | fetched only when named | Binary contents of the first attachment. | |
attachment1 |
varchar2 |
Attachment 1 MIME Type | fetched only when named | MIME type of the first attachment. | |
attachment1 |
varchar2 |
Attachment #1 File Name | fetched only when named | File name of the first attachment. | |
attachment2 |
blob |
Attachment 2 Contents | fetched only when named | Binary contents of the second attachment. | |
attachment2 |
varchar2 |
Attachment 2 MIME Type | fetched only when named | MIME type of the second attachment. | |
attachment2 |
varchar2 |
Attachment #2 File Name | fetched only when named | File name of the second attachment. | |
attachment3 |
blob |
Attachment 3 Contents | fetched only when named | Binary contents of the third attachment. | |
attachment3 |
varchar2 |
Attachment 3 MIME Type | fetched only when named | MIME type of the third attachment. | |
attachment3 |
varchar2 |
Attachment #3 File Name | fetched only when named | File name of the third attachment. | |
bcc |
varchar2 |
Blank Carbon Copy Recipient Email Addresses | fetched only when named | List of Blank Carbo Copy recipients, separated by ';'. | |
body |
varchar2 |
Body Text | fetched only when named | Body text of the mail. | |
body |
varchar2 |
Body Encoding | fetched only when named | Character set for encoding mail body. | |
cc |
varchar2 |
Carbon Copy Recipient Email Addresses | fetched only when named | List of email addresses of the recipients of a copy, separated by ';'. | |
date |
datetime |
Date End (UTC) | fetched only when named | Date end (UTC). | |
date |
datetime |
Date Start (UTC) | fetched only when named | Date start (UTC). | |
enable |
boolean |
SMTP Enable SSL | fetched only when named | Whether to use SSL on SMTP transport. | |
error |
varchar2 |
Error Message Code | fetched only when named | Message code of the error. | |
error |
varchar2 |
Error Message Text | fetched only when named | Message text of the error. | |
fail |
boolean |
On Error | fetched only when named | Fail on error. | |
from |
varchar2 |
From Email Address | fetched only when named | FROM email address. | |
from |
varchar2 |
From Name | fetched only when named | FROM name. | |
headers |
varchar2 |
Mail Headers | fetched only when named | List of headers, per header separated by ';'. The header name and value are separated by a ':'. | |
id |
number |
Mail ID | fetched only when named | ID. | |
is |
varchar2 |
Body is HTML Text | fetched only when named | True when the contents of the body are formatted as HTML, false when formatted as plain text. | |
minimum |
int32 |
Minimum Delivery Duration (ms) | fetched only when named | Minimum deliver duration in milliseconds for the SMTP send plus inserted sleep when SMTP send finished earlier than the minimum. | |
orig |
varchar2 |
Original System Reference | fetched only when named | Original system reference. | |
priority |
number |
Priority | fetched only when named | Priority of the mail; negative is bulk, 0 is neutral, positive is urgent. | |
reply |
varchar2 |
Reply to Email Address | fetched only when named | REPLY TO email address. | |
reply |
varchar2 |
Reply to Name | fetched only when named | REPLY TO name. | |
smtp |
varchar2 |
SMTP Server Host | fetched only when named | Host name or IP-address of the SMTP server to send the mail through. | |
smtp |
number |
SMTP Server Port | fetched only when named | Port number of the SMTP server. | |
smtp |
varchar2 |
SMTP Server Password | fetched only when named | Password for authentication of the user on the SMTP server. | |
smtp |
varchar2 |
SMTP Server Log On Code | fetched only when named | User name for authentication on the SMTP server. | |
subject |
varchar2 |
Subject | fetched only when named | Subject of the mail. | |
subject |
varchar2 |
Subject Encoding | fetched only when named | Character set for encoding subject. | |
successful |
boolean |
Succesful | fetched only when named | Result of the sending was successful. | |
to |
varchar2 |
Recipient Email Addresses | fetched only when named | List of email addresses of the recipients, separated by ';'. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: