Help
is a function that transmits the help command. It returns a record
of type
utl_smtp.reply.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
C
|
UTL_SMTP.CONNECTION
|
IN | OUT
|
|
|
DOMAIN
|
VARCHAR2
|
IN
|
NULL
|
Table 6.145:
Help Parameters
Mail
is both a procedure and function that initiates a mail transaction.
The function returns a record of type
utl_smtp.reply.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
C
|
UTL_SMTP.CONNECTION
|
IN | OUT
|
|
|
SENDER
|
VARCHAR2
|
IN
|
|
|
PARAMETERS
|
VARCHAR2
|
IN
|
NULL
|
Table 6.146:
Mail Parameters
NOOP
is both a procedure and function that performs a NULL command. It does
not actually send the mail, just prepares to send it and requires
subsequent calls to RCPT and DATA to complete the transaction. The
function returns a record of type
utl_smtp.reply.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
C
|
UTL_SMTP.CONNECTION
|
IN | OUT
|
|
Table 6.147:
NOOP Parameters
Open_connection
is an overloaded function that takes two fairly different forms.
However, each opens a connection to the SMTP server; they simply
differ in their return styles. The first version returns the
connection handle via and
out parameter and returns
utl_smtp.reply, shown here.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
HOST
|
VARCHAR2
|
IN
|
|
|
PORT
|
PLS_INETGER
|
IN
|
25
|
|
C
|
UTL_SMTP.CONNECTION
|
OUT
|
|
|
TX_TIMEOUT
|
PLS_INETGER
|
IN
|
NULL
|
Table 6.148:
Open_connection Parameters
The second version of
open_connection simply returns the connect handle, which
is type
utl_smtp.connection.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
HOST
|
VARCHAR2
|
IN
|
|
|
PORT
|
PLS_INETGER
|
IN
|
25
|
|
TX_TIMEOUT
|
PLS_INETGER
|
IN
|
NULL
|
Table 6.149:
Open_connections Parameters, 2nd Version
Open_data
is both a procedure and a function that transmits the DATA command to
the SMTP server, after which one can then call
write_data and
write_raw_data. The function returns a record of type
utl_smtp.reply.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
C
|
UTL_SMTP.CONNECTION
|
IN | OUT
|
|
Table 6.150:
Open_data Parameter
Quit
is both a procedure and function that terminates the SMTP session. The
function returns a record of type
utl_smtp.reply.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
C
|
UTL_SMTP.CONNECTION
|
IN | OUT
|
|
Table 6.151:
Quit Parameter
RCPT
is both a procedure and function that specifies the recipient of the
email. The function returns a record of type
utl_smtp.reply.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
C
|
UTL_SMTP.CONNECTION
|
IN | OUT
|
|
|
RECIPIENT
|
VARCHAR2
|
IN
|
|
|
PARAMETERS
|
VARCHAR2
|
IN
|
NULL
|
Table 6.152:
RCPT Parameters
RSET
is both a procedure and function that simply terminates the current
mail transaction. The function returns a record of type
utl_smtp.reply.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
C
|
UTL_SMTP.CONNECTION
|
IN | OUT
|
|
Table 6.153:
RSET Parameter
VRFY
is a function that verifies or validates the destination email
address. It returns a record of type
utl_smtp.reply.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
C
|
UTL_SMTP.CONNECTION
|
IN | OUT
|
|
|
DOMAIN
|
VARCHAR2
|
IN
|
|
Table 6.154:
VRFY Parameters
Write_data
is a procedure that writes a portion of the email message and where
repeat calls simply append data to the message.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
C
|
UTL_SMTP.CONNECTION
|
IN | OUT
|
|
|
DATA
|
VARCHAR2
|
IN
|
|
Table 6.155:
Write_data Parameters
Write_raw_data
is also a procedure that writes a portion of the email message and
where repeat calls append data to the message. The main difference is
that the
DATA parameter is now RAW.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
C
|
UTL_SMTP.CONNECTION
|
IN | OUT
|
|
|
DATA
|
RAW
|
IN
|
|
Table 6.156:
Write_raw_data parameters
UTL_SMTP is covered in more detail from the developer’s perspective in
Chapter 9.
