SET_MAILHOST Procedure

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

Syntax

DBMS_AQELM.SET_MAILHOST (

mailhost  IN  VARCHAR2);

Parameters

Table 6-2 shows the parameters for the SET_MAILHOST procedure.

Table 6-2 SET_MAILHOST Procedure Parameters

Parameter	Description
mailhost	The SMTP server host name.