SET_MAILPORT Procedure

This procedure sets the port number for the SMTP server. As part of the configuration for e-mail notifications, a user with AQ_ADMINISTRATOR_ROLE or with EXECUTE permissions on DBMS_AQELM package needs to set the port number before registering for e-mail notifications. The database will use this SMTP server port number to send out e-mail notifications. If not set, the SMTP mailport defaults to 25.

Syntax

DBMS_AQELM.SET_MAILPORT (

mailport  IN NUMBER);

Parameters

Table 6-4 shows the parameters for the SET_MAILPORT procedure.

Table 6-4 SET_MAILPORT Procedure Parameters

Parameter	Description
mailport	The SMTP server port number.