Results for UTL_SMTP


21 to 40 of 94 results. Prev  Next
Results per page:   20  | 40 | 60


Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

Usage NotesThese are the APIs used to invoke generic SMTP commands. Use command() if only a single reply line is expected. Use command_replies() if multiple reply lines are expected (in other words, EXPN or HELP ). For command(), if multiple reply lines are returned from the SMTP server, it returns the last reply line only.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

Usage NotesThe ehlo() interface is identical to helo(), except that it allows the server to return more descriptive information about its configuration. [RFC1869] specifies the format of the information returned, which the PL/SQL application can retrieve using the functional form of this call. For compatibility with helo(), each line of text returned by the server begins with status code 250.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

Usage NotesThis command does not send the message; it simply begins its preparation. It must be followed by calls to rcpt() and data() to complete the transaction. The connection to the SMTP server must be open and a helo() or ehlo() command must have already been sent. The expected response from the server is a message beginning with status code 250.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

Usage NotesTo send a message to multiple recipients, call this routine multiple times. Each invocation schedules delivery to a single e-mail address. The message transaction must have been begun by a prior call to mail(), and the connection to the mail server must have been opened and initialized by prior calls to open_connection() and helo() or ehlo(), respectively. The expected response from the server is

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

ParametersTable 100-13 data Function Parameters Parameter Description c (IN OUT NOCOPY) The SMTP Connection. body (IN OUT NOCOPY) The text of the message to be sent, including headers, in [RFC822] format.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

ParametersTable 100-16 vrfy Function Parameters Parameter Description c (IN OUT NOCOPY) The SMTP connection. recipient (IN OUT NOCOPY) The e-mail address to be verified.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

ParameterTable 100-17 noop Function Parameters Parameter Description c (IN OUT NOCOPY) The SMTP connection.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

Usage NotesThe quit() command informs the SMTP server of the client's intent to terminate the session. It then closes the connection established by open_connection(), which must have been called before executing this command. If a mail transaction is in progress when quit() is issued, it is abandoned in the same manner as rset(). The function form of this command returns a single line beginning with the status

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

FieldsTable 100-6 reply, replies Record Type Fields Field Description code The 3-digit reply code. text The text message of the reply.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

ParametersTable 100-11 Mail Function Parameters Parameter Description c (IN NOCOPY) The SMTP connection. sender (IN OUT NOCOPY) The e-mail address of the user sending the message. parameters (IN OUT NOCOPY) The additional parameters to MAIL command as defined in Section 6 of [RFC1869]. It should follow the format of \"XXX=XXX (XXX=XXX....)\".

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

data FunctionThis function specifies the body of an e-mail message.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

SyntaxUTL_SMTP.VRFY ( c IN OUT NOCOPY connection recipient IN OUT NOCOPY) RETURN reply;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

SyntaxUTL_SMTP.QUIT ( c IN OUT NOCOPY connection) RETURN VARCHAR2;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

command(), command_replies() FunctionsThese functions perform generic SMTP commands.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

SyntaxUTL_SMTP.COMMAND ( c IN connection, cmd IN VARCHAR2, arg IN VARCHAR2 DEFAULT NULL) RETURN reply; UTL_SMTP.COMMAND ( c IN connection, cmd IN VARCHAR2, arg IN ARCHAR2 DEFAULT NULL); UTL_SMTP.COMMAND_REPLIES ( c IN connection, cmd IN VARCHAR2, arg IN VARCHAR2 DEFAULT NULL) RETURN replies;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

ParametersTable 100-8 command (), command_replies () Function Parameters Parameter Description c (IN) The SMTP connection. cmd (IN) The SMTP command to send to the server. arg (IN) The optional argument to the SMTP argument. A space will be inserted between cmd and arg.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

SyntaxUTL_SMTP.HELO ( c IN NOCOPY connection, domain IN NOCOPY) RETURN reply; UTL_SMTP.HELO ( c IN NOCOPY connection, domain IN NOCOPY);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

ParametersTable 100-9 helo Function Parameters Parameter Description c (IN NOCOPY) The SMTP connection. domain (IN NOCOPY) The domain name of the local (sending) host. Used for identification purposes.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

ParametersTable 100-10 ehlo Function Parameters Parameter Description c (IN NOCOPY) The SMTP connection. domain (IN NOCOPY) The domain name of the local (sending) host. Used for identification purposes.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

rcpt FunctionThis function specifies the recipient of an e-mail message.





Was this page helpful?

Integrated Cloud Applications & Platform Services