Oracle DBMS_AQELM
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose Provides subprograms to manage the configuration of Oracle Streams Advanced Queuing (AQ) asynchronous notification by e-mail and HTTP
AUTHID DEFINER
Dependencies
DBMS_AQELM_LIB UTL_SMTP UTL_TCP
UTL_HTTP    
Documented Yes
First Available 9.0.1
Security Model Owned by SYS with EXECUTE granted to SYSTEM and the AQ_ADMINISTRATOR_ROLE and EXECUTE_CATALOG_ROLE roles
Source {ORACLE_HOME}/rdbms/admin/dbmsaqem.plb
Subprograms
 
GET_MAILHOST
Returns the host name for the SMTP server that the database will uses send out e-mail notifications dbms_aqelm.get_mailhost(mailhost OUT VARCHAR2);
See the AQELM Demo Below
 
GET_MAILPORT
Returns the port number for the SMTP server dbms_aqelm.get_mailport(mailport OUT NUMBER);
See the AQELM Demo Below
 
GET_PROXY
Returns the name of the proxy server dbms_aqelm.get_proxy(proxy OUT VARCHAR2, no_proxy_domains OUT VARCHAR2);
See the AQELM Demo Below
 
GET_SENDFROM
Returns the sent-from e-mail address dbms_aqelm.get_sendfrom(sendfrom OUT VARCHAR2);
See the AQELM Demo Below
 
HTTP_SEND
Undocumented

Appears to send a specified line "WHAT" at a specified line number "WHATL" for a named URL

Returns 404 if the URL does not exist.
dbms_aqelm.http_send(
url         IN  VARCHAR2,
what        IN  VARCHAR2,
whatl       IN  NUMBER,
status_code OUT VARCHAR2);
set serveroutput on

DECLARE
 sc VARCHAR2(30);
 ls VARCHAR2(100) := 'TEST';
BEGIN
  dbms_aqelm.http_send('www.morganslibrary.org/index.html', ls, 2, sc);
  dbms_output.put_line(sc);
END;
/

DECLARE
 sc VARCHAR2(30);
 ls VARCHAR2(100) := 'TEST';
BEGIN
  dbms_aqelm.http_send('www.morganslibrary.org/test.html', ls, 30, sc);
  dbms_output.put_line(sc);
END;
/
 
SEND_EMAIL
Undocumented dbms_aqelm.send_email(sendto IN VARCHAR2, text IN VARCHAR2);
TBD
 
SET_MAILHOST
Sets the host name for the SMTP server that the database will uses send out e-mail notifications dbms_aqelm.set_mailhost(mailhost IN VARCHAR2);
See the AQELM Demo Below
 
SET_MAILPORT
Sets the port number for the SMTP server dbms_aqelm.set_mailport(mailport IN NUMBER);
See the AQELM Demo Below
 
SET_PROXY
Sets the name of the proxy server dbms_aqelm.set_proxy(
proxy            IN VARCHAR2,
no_proxy_domains IN VARCHAR2);
See the AQELM Demo Below
 
SET_SENDFROM
Sets the sent-from e-mail address dbms_aqelm.set_sendfrom(sendfrom IN VARCHAR2);
See the AQELM Demo Below
 
Demo
Demo Code set serveroutput on

DECLARE
 mh VARCHAR2(100);
 mp NUMBER;
 sf VARCHAR2(50);
 np VARCHAR2(50);
 px VARCHAR2(50);
BEGIN
  dbms_aqelm.set_mailhost('morganslibrary.org');
  dbms_aqelm.set_mailport(25);
  dbms_aqelm.set_sendfrom('mailsys@morganslibrary.org');
  dbms_aqelm.set_proxy('proxyserver@morganslibrary.org');
  COMMIT;

  dbms_aqelm.get_mailhost(mh);
  dbms_output.put_line('Mail Host: ' || mh);
  dbms_aqelm.get_mailport(mp);
  dbms_output.put_line('Mail Port: ' || mp);
  dbms_aqelm.get_sendfrom(sf);
  dbms_output.put_line('Send From: ' || sf);
  dbms_aqelm.get_proxy(np, px);
  dbms_output.put_line('No Proxy: ' || np);
  dbms_output.put_line('Proxy: ' || px);
END;
/

Related Topics
Advanced Queuing Demo 1
Advanced Queuing RAC Demo
DBMS_ALERT
DBMS_AQ
DBMS_AQADM
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_IMP_ZECURITY
Packages

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved