December 2002
Intermediate to advanced
928 pages
85h 29m
English
FUNCTION UTL_SMTP.OPEN_CONNECTION
(host IN VARCHAR2,
port IN PLS_INTEGER DEFAULT 25,
[c OUT CONNECTION,]
tx_timeout IN PLS_INTEGER DEFAULT NULL)
RETURN {REPLY | CONNECTION};
Opens a connection to an SMTP server on port of host with tx_timeout. If connection c is passed with the call, the return is a reply record type; if not, a connection record type is returned.
FUNCTION UTL_SMTP.COMMAND
(c IN CONNECTION,
ord IN VARCHAR2,
arg IN VARCHAR2 DEFAULT NULL)
RETURN REPLY;
PROCEDURE UTL_SMTP.COMMAND
(c IN CONNECTION,
cmd IN VARCHAR2,
arg IN VARCHAR2 DEFAULT NULL);
FUNCTION UTL_SMTP.COMMAND_REPLIES
(c IN CONNECTION,
ord IN VARCHAR2,
arg IN VARCHAR2 DEFAULT NULL)
RETURN REPLIES;
Performs cmd with arg for connection c. If cmd generates a reply, use the function. If cmd generates multiple replies, use the COMMAND_REPLIES function.
FUNCTION UTL_SMTP.HELO
(c IN NOCOPY CONNECTION,
domain IN NOCOPY)
RETURN REPLY;
PROCEDURE UTL_SMTP.HELO
(c IN NOCOPY CONNECTION,
domain IN NOCOPY);
Performs handshaking with c. domain identifies the local host.
FUNCTION UTL_SMTP.EHLO
(c IN NOCOPY CONNECTION,
domain IN NOCOPY)
RETURN REPLIES;
PROCEDURE UTL_SMTP.EHLO
(c IN NOCOPY CONNECTION,
domain IN NOCOPY);
Performs handshaking with c with extended information returned. domain identifies the local host.
FUNCTION UTL_SMTP.MAIL
(c IN NOCOPY CONNECTION,
sender IN OUT NOCOPY,
parameters IN OUT NOCOPY)
RETURN REPLY;
PROCEDURE UTL_SMTP.MAIL
(c IN NOCOPY CONNECTION,
sender IN OUT NOCOPY,
parameters IN OUT NOCOPY); ...