Results for UTL_SMTP


1 to 60 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, 1 of 3

100 UTL_SMTPUTL_SMTP is designed for sending e-mail over Simple Mail Transfer Protocol (SMTP). It does not have … UTL_SMTP, all text data (in other words, those in VARCHAR2 ) will be converted to US7ASCII before it is … multibyte data using 8-bit MIME encoding. UTL_SMTP provides for SMTP communication as specified in … chapter discusses the

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

UTL_SMTP, 2 of 3

Summary of UTL_SMTP SubprogramsTable 100-4 UTL_SMTP Subprograms   Subprogram Description connection Record Type This is a PL/SQL

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

UTL_SMTP, 1 of 3

Exceptions, Limitations, and Reply CodesExceptions Table 100-1 lists the exceptions that can be raised by the API of the UTL_SMTP package … . The network error is transferred to a reply code of 421- service not available. Table 100-1 UTL_SMTP

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

UTL_SMTP, 2 of 3

SyntaxUTL_SMTP.OPEN_DATA ( c IN OUT NOCOPY connection) RETURN reply; UTL_SMTP.OPEN_DATA ( c IN OUT NOCOPY connection); UTL_SMTP.WRITE_DATA ( c IN OUT NOCOPY connection, data IN OUT NOCOPY); UTL_SMTP.WRITE_RAW_DATA ( c IN OUT NOCOPY connection data IN OUT NOCOPY); UTL_SMTP.CLOSE_DATA ( c IN OUT NOCOPY connection) RETURN reply; UTL_SMTP.CLOSE_DATA ( c IN OUT NOCOPY connection);

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

UTL_SMTP, 2 of 3

Usage NotesThe server attempts to resolve the destination address recipient. If successful, it returns the recipient's full name and fully qualified mailbox path. The connection to the server must have already been established via open_connection() and helo() / ehlo() before making this request. Successful verification returns one or more lines beginning with status code 250 or 251.

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

UTL_SMTP, 2 of 3

Usage NotesThis command has no effect except to elicit a successful reply from the server. It can be issued at any time after the connection to the server has been established with open_connection(). The noop() command can be used to verify that the server is still connected and is listening properly. This command will always reply with a single line beginning with status code 250.

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

UTL_SMTP, 2 of 3

quit FunctionThis function terminates an SMTP session and disconnects from the server.

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

UTL_SMTP, 2 of 3

reply, replies Record TypesThese are PL/SQL record types used to represent an SMTP reply line. Each SMTP reply line consists of a reply code followed by a text message. While a single reply line is expected for most SMTP commands, some SMTP commands expect multiple reply lines. For those situations, a PL/SQL table of reply records is used to represent multiple reply lines.

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

UTL_SMTP, 2 of 3

Related Functionsehlo() ehlo Function This function performs initial handshaking with SMTP server after connecting, with extended information returned.

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

UTL_SMTP, 2 of 3

SyntaxUTL_SMTP.RCPT ( c IN OUT NOCOPY connection, recipient IN OUT NOCOPY, parameters IN OUT NOCOPY) RETURN reply; UTL_SMTP.RCPT ( c IN OUT NOCOPY connection recipient IN OUT NOCOPY, parameters IN OUT NOCOPY); Table 100-12 rcpt Function Parameters Parameter Description c (IN OUT NOCOPY) The SMTP connection. recipient (IN OUT NOCOPY) The e-mail address of the user to which the message is being sent. parameters

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

UTL_SMTP, 2 of 3

SyntaxUTL_SMTP.DATA ( c IN OUT NOCOPY connection body IN OUT NOCOPY) RETURN reply; UTL_SMTP.DATA ( c IN OUT NOCOPY connection body IN OUT NOCOPY);

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

UTL_SMTP, 2 of 3

ParametersTable 100-14 open_data(), write_data(), write_raw_data(), close_data() Function Parameters Parameter Description c (IN OUT NOCOPY) The SMTP connection. data (IN OUT NOCOPY) The portion of 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

rset FunctionThis function aborts the current mail transaction.

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

UTL_SMTP, 2 of 3

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

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

UTL_SMTP, 2 of 3

ParameterTable 100-18 quit 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

Fieldsthe UTL_SMTP package waits before giving up in a read or write operation in this connection. In read

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

UTL_SMTP, 2 of 3

Usage NotesThe read-only fields in a connection record are used to return information about the SMTP connection after the connection is successfully made with open_connection(). Changing the values of these fields has no effect on the connection. The fields private_xxx are for implementation use only. You should not modify these fields.

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

UTL_SMTP, 2 of 3

SyntaxTYPE reply IS RECORD ( code PLS_INTEGER, -- 3-digit reply code text VARCHAR2(508) -- text message ); TYPE replies IS TABLE OF reply INDEX BY BINARY_INTEGER; -- multiple reply lines

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

UTL_SMTP, 2 of 3

open_connection FunctionThis function opens a connection to an SMTP server.

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

UTL_SMTP, 2 of 3

Usage NotesThe expected response from the server is a message beginning with status code 220. The version of open_connection() API that returns utl_smtp.connection record is actually the procedure version of open_connection that checks the reply code returned by an SMTP server when the connection is first established. A timeout on the write operations feature is not supported in the current release of this package.

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.

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

UTL_SMTP, 2 of 3

SyntaxUTL_SMTP.RSET ( c IN OUT NOCOPY connection) RETURN reply; UTL_SMTP.RSET ( c IN OUT NOCOPY connection);

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

UTL_SMTP, 2 of 3

ParametersTable 100-15 rset 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

connection Record TypeThis is a PL/SQL record type used to represent an SMTP connection.

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

UTL_SMTP, 2 of 3

SyntaxUTL_SMTP.OPEN_CONNECTION ( host IN VARCHAR2, port IN PLS_INTEGER DEFAULT 25, c OUT connection, tx_timeout IN PLS_INTEGER DEFAULT NULL) RETURN reply; UTL_SMTP.OPEN_+CONNECTION ( host IN VARCHAR2, port IN PLS_INTEGER DEFAULT 25, tx_timeout IN PLS_INTEGER DEFAULT NULL) RETURN connection;

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

UTL_SMTP, 2 of 3

Parameters(IN) The time in seconds that the UTL_SMTP package waits before giving up in a read or write

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

UTL_SMTP, 2 of 3

SyntaxUTL_SMTP.EHLO ( c IN OUT NOCOPY connection, domain IN NOCOPY) RETURN replies; UTL_SMTP.EHLO ( c IN OUT NOCOPY connection, domain IN NOCOPY);

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

UTL_SMTP, 2 of 3

Usage NotesThe application must ensure that the contents of the body parameter conform to the MIME(RFC822) specification. The data() routine will terminate the message with a. sequence (a single period at the beginning of a line), as required by RFC821. It will also translate any sequence of. (single period) in body to.. (double period). This conversion provides the transparency as described in Section 4.5.2

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

UTL_SMTP, 2 of 3

open_data(), write_data(), write_raw_data(), close_data() FunctionsThese APIs provide more fine-grain control to the data() API; in other words, to the SMTP DATA operation. open_data() sends the DATA command. After that, write_data() and write_raw_data() write a portion of the e-mail message. A repeat call to write_data() and write_raw_data() appends data to the e-mail message. The close_data() call ends the e-mail message by sending the sequence. (a single period

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

UTL_SMTP, 2 of 3

Usage NotesThis command allows the client to abandon a mail message it was in the process of composing. No mail will be sent. The client can call rset() at any time after the connection to the SMTP server has been opened via open_connection(). The server will always respond to RSET with a message beginning with status code 250.

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

UTL_SMTP, 3 of 3

ExampleThe following example illustrates how UTL_SMTP is used by an application to send e-mail. The

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

UTL_SMTP, 2 of 3

helo FunctionThis function performs initial handshaking with SMTP server after connecting.

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

UTL_SMTP, 2 of 3

Related Functionshelo() mail Function This function initiates a mail transaction with the server. The destination is a mailbox.

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

UTL_SMTP, 2 of 3

SyntaxUTL_SMTP.MAIL ( c IN OUT NOCOPY connection, sender IN OUT NOCOPY, parameters IN OUT NOCOPY) RETURN reply; UTL_SMTP.MAIL ( c IN OUT NOCOPY connection, sender IN OUT NOCOPY, parameters IN OUT NOCOPY);

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

UTL_SMTP, 2 of 3

Usage NotesThe calls to open_data(), write_data(), write_raw_data() and close_data() must be made in the right order. A program calls open_data() to send the DATA command to the SMTP server. After that, it can call write_data() or write_raw_data() repeatedly to send the actual data. The data is terminated by calling close_data(). After open_data() is called, the only APIs that can be called are write_data(),

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

UTL_SMTP, 2 of 3

Related Functionsexpn() noop() Function The command.

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

UTL_SMTP, 2 of 3

Related Functionsrset() Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback

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

UTL_SMTP, 2 of 3

SyntaxTYPE connection IS RECORD ( host VARCHAR2(255), -- remote host name port PLS_INTEGER, -- remote port number tx_timeout PLS_INTEGER, -- Transfer time-out (in seconds) private_tcp_con utl_tcp.connection, -- private, for implementation use private_state PLS_INTEGER -- private, for implementation use );

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

UTL_SMTP, 2 of 3

Usage NotesRFC 821 specifies that the client must identify itself to the server after connecting. This routine performs that identification. The connection must have been opened via a call to open_connection() before calling this routine. 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

Related Functionsquit() vrfy Function This function verifies the validity of a destination e-mail address.

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

Oracle9i Supplied PL/SQL Packages and Types Reference -- Index

Hhelo() function helo() function of UTL_SMTP, 100-9 hierarchy hierarchy removing, 80-62 history option history option EnableVersioning procedure, 80-28





Was this page helpful?

Integrated Cloud Applications & Platform Services