PL/SQL Email Client

Index

A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z  
A
add_bcc_filter   (mail_filter)
Adds a filter for the Email recipient attribute CC.

add_body_filter   (mail_filter)
Adds a filter to search within the email body.

add_cc_filter   (mail_filter)
Adds a filter for the Email recipient attribute TO.

add_deleted_filter   (mail_filter)
Adds a filter for the "DELETED" flag of an email.

add_from_filter   (mail_filter)
Adds a filter for the Email sender attribute (FROM).

add_header_filter   (mail_filter)
Adds a filter for any given Email haeder.

add_receiveddate_filter   (mail_filter)
Adds a filter for the datetime at which the Email was received by the mail server.

add_seen_filter   (mail_filter)
Adds a filter for the "SEEN" flag of an email.

add_sentdate_filter   (mail_filter)
Adds a filter for the datetime at which the Email was sent.

add_size_filter   (mail_filter)
Adds a filter for the message size.

add_subject_filter   (mail_filter)
Adds a filter for the Email subject.

add_to_filter   (mail_filter)
Adds a filter for the Email recipient attribute BCC.

answered   (mail_t)
Indicates whether the message is marked as "answered".

B
C
child_count   (mail_part_t)
For body parts (which are multipart objects): the number of child body part objects.

clear_filters   (mail_filter)
Clears all previously set mail filters.

close_folder   (mail_client)
closes the currently open mailbox folder.

connect_server   (mail_client)
Connects to a mailserver.

content_disposition   (mail_part_t)
Content disposition (INLINE or ATTACHMENT) of this body part.

content_type   (mail_part_t)
Content type of this body part.

content_type   (mail_t)
Content Type of the message.

copy_message   (mail_t)
Copies the message to another mailbox folder.

create_folder   (mail_client)
Creates a folder under the current folder

D
delete_folder   (mail_client)
Deletes a subfolder under the current folder

deleted   (mail_t)
Indicates whether the message is marked as "deleted".

disconnect_server   (mail_client)
disconnects from the server.

dump_blob   (mail_t)
Dumps the message "as it is"; i.e. does not interpret the message strcuture.

dump_clob   (mail_t)
Dumps the message "as it is"; i.e. does not interpret the message strcuture.

E
expunge_folder   (mail_client)
performs the "expunge" operation on the mailbox folder: permanatly deletes all messages marked as "deleted".

F
FILTER_COMB_AND   (mail_filter)
Constant for mail filter combination: {filter1} AND {filter2} AND ... AND {filterN}

FILTER_COMB_NOT_AND   (mail_filter)
Constant for mail filter combination: NOT({filter1} AND {filter2} AND ... AND {filterN})

FILTER_COMB_NOT_OR   (mail_filter)
Constant for mail filter combination: NOT({filter1} OR {filter2} OR ... AND {filterN})

FILTER_COMB_OR   (mail_filter)
Constant for mail filter combination: {filter1} OR {filter2} OR ... OR {filterN}

G
get_bodypart_content_blob   (mail_t)
Returns the content of the messages' body part as BLOB.

get_bodypart_content_clob   (mail_t)
Returns the content of the messages' body part as CLOB.

get_bodypart_content_type   (mail_t)
Returns the messages' content type

get_bodypart_content_varchar2   (mail_t)
Returns the content of the messages' body part as VARCHAR2.

get_bodypart_multipart_count   (mail_t)
Returns for a messages' body part (which is of type "multipart") the number of child body parts.

get_content_clob   (mail_t)
Tries to retrieve the text content of simple or multipart messages as a <b>CLOB</b>.

get_content_type   (mail_t)
Returns the messages' content type

get_content_varchar2   (mail_t)
Tries to retrieve the text content of simple or multipart messages as <b>VARCHAR2</b>.

get_fetch_limit   (mail_client)
Returns the current Fetch Limit for GET_MAIL_HEADERS.

get_folder_fullname   (mail_client)
Returns the full name of the current folder

get_folder_name   (mail_client)
Returns the short name of the current folder

get_folders   (mail_client)
Retrieves the current folders' subfolder list

get_headers   (mail_t)
Lists all email headers of the specified body part.

get_headers   (mail_t)
Lists all message headers

get_mail_headers   (mail_client)
Retrieve all messages in the folder as <i>TABLE OF MAIL_T</i>.

get_mail_headers_p   (mail_client)
Retrieve all messages in the folder as <i>TABLE OF MAIL_T</i>.

get_message   (mail_client)
Get the Message object corresponding to the given message number.

get_message_count   (mail_client)
Returns the message count within the current folders

get_multipart_count   (mail_t)
Returns for multipart messages the content type of a specific body part.

get_new_message_count   (mail_client)
Returns the "New Message" count within the current folders

get_priority   (mail_t)
Returns the messages' priority flag

get_receivedate   (mail_t)
Returns the datetime at which the message has been received by the mail server.

get_recipients   (mail_t)
Returns all message recipients as table of MAIL_ADDR_T

get_simple_content_clob   (mail_t)
Retrieves the content of a simple text message as a CLOB.

get_simple_content_varchar2   (mail_t)
Retrieves the content of a simple text message as VARCHAR2.

get_size   (mail_t)
Returns the size of the specified body part in bytes.

get_size   (mail_t)
Returns the size of the whole message in bytes.

get_structure   (mail_t)
Returns (for multipart messages) the information about the contained body part hierarchy as <i>table of MAIL_PART_T</i>.

get_uid   (mail_t)
Returns the message UID (if available)

get_unread_message_count   (mail_client)
Returns the "Unread Message" count within the current folders

H
I
is_connected   (mail_client)
Checks whether the session is currently connected to a mailserver.

J
K
L
M
mark_deleted   (mail_t)
Mark the message as "deleted".

mark_read   (mail_t)
Mark the message as "read".

mark_undeleted   (mail_t)
Removed the "deleted" mark from the message.

mark_unread   (mail_t)
Mark the message as "unread", therefore "new".

message_size   (mail_t)
Message size in bytes.

move_message   (mail_t)
Moves the message to another mailbox folder; i.e. copies the message and marks it as deleted.

msg_number   (mail_t)
A Message object's message number is the relative position of this Message in its Folder.

N
name   (mail_header_t)
Name of the header field

O
open_child_folder   (mail_client)
Opens a child folder

open_folder   (mail_client)
Opens a mailbox folder

open_inbox   (mail_client)
Opens the mailbox folder "INBOX".

open_parent_folder   (mail_client)
Opens the parent folder.

P
parent_index   (mail_part_t)
Identifier of the parent body part for usage in the <b>MAIL_T</b> methods.

part_size   (mail_part_t)
Size (in bytes) of this body part.

partindex   (mail_part_t)
Identifier for this body part for usage in the <b>MAIL_T</b> methods.

PROTOCOL_IMAP   (mail_client)
Constant for procedure <b>CONNECT_SERVER</b>: Use the IMAP protocol

PROTOCOL_POP3   (mail_client)
Constant for procedure <b>CONNECT_SERVER</b>: Use the POP3 protocol

Q
R
rcpt_address   (mail_addr_t)
Recipients email address

rcpt_name   (mail_addr_t)
Recipient name (clear text)

rcpt_type   (mail_addr_t)
Recipient type ("TO" or "CC")

read   (mail_t)
Indicates whether the message is marked as "read".

recent   (mail_t)
Indicates whether the message is marked as "recent".

rename_folder   (mail_client)
Renames a folder

rfc_decode   (mail_client)
Decodes encoded special characters (unicode, etc) to normal text.

S
sender   (mail_t)
Sender name of the message

sender_email   (mail_t)
Sender email of the message

sent_date   (mail_t)
Date on which the message was sent.

set_fetch_limit   (mail_client)
Sets the Fetch Limit for GET_MAIL_HEADERS.

set_filter_combination   (mail_filter)
Determines how multiple search filters are to be combined.

subject   (mail_t)
Subject of the message

T
U
V
value   (mail_header_t)
Value of the header field

X
Y
Z
PL/SQL Email Client