OPEN_CONNECTION procedure - Open a connection to an SMTP server

The OPEN_CONNECTION procedure opens a connection to an SMTP server.

Syntax

Read syntax diagramSkip visual syntax diagramUTL_SMTP.OPEN_CONNECTION( host,port,connection ,tx_timeout,reply)

Parameters

host
An input argument of type VARCHAR(255) that specifies the name of the SMTP server.
port
An input argument of type INTEGER that specifies the port number on which the SMTP server is listening.
connection
An output argument of type CONNECTION that returns a connection handle to the SMTP server.
tx_timeout
An optional input argument of type INTEGER that specifies the time out value, in seconds. To instruct the procedure not to wait, set this value to 0. To instruct the procedure to wait indefinitely, set this value to NULL.
reply
An output argument of type REPLY that returns a single reply line from the SMTP server. It is the last reply line if multiple reply lines are returned by the SMTP server.

Authorization

EXECUTE privilege on the UTL_SMTP module.