Oracle in a Nutshell

Calls

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); ...