The DBMS_AQELM
package provides subprograms to manage the configuration of Oracle Streams Advanced Queuing (AQ) asynchronous notification by e-mail and HTTP.
See Also:
Oracle Streams Advanced Queuing User's Guide and Reference for detailed information aboutDBMS_AQELM
This chapter contains the following topic:
Table 18-1 DBMS_ALERT Package Subprograms
Subprogram | Description |
---|---|
Sets the host name for the SMTP server that the database will uses send out e-mail notifications |
|
Sets the port number for the SMTP server |
|
Sets the sent-from e-mail address |
This procedure sets the host name for the SMTP server. The database uses this SMTP server host name to send out e-mail notifications.
DBMS_AQELM.SET_MAILHOST ( mailhost IN VARCHAR2);
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.
This procedure sets the port number for the SMTP server.
DBMS_AQELM.SET_MAILPORT ( mailport IN NUMBER);
Table 18-3 SET_MAILPORT Procedure Parameters
Parameter | Description |
---|---|
|
SMTP server port number. |
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 uses this SMTP server port number to send out e-mail notifications. If not set, the SMTP mailport defaults to 25
This procedure sets the sent-from e-mail address. This e-mail address is used in the sent-from field in all the e-mail notifications sent out by the database to the registered e-mail addresses.
DBMS_AQELM.SET_SENDFROM ( sendfrom IN VARCHAR2);
Table 18-4 SET_SENDFROM Procedure Parameters
Parameter | Description |
---|---|
|
The sent-from e-mail address. |
As part of the configuration for e-mail notifications, a user with AQ_ADMINISTRATOR_ROLE
or with EXECUTE
permissions on the DBMS_AQELM
package should set the sent-from address before registering for e-mail notifications