Oracle DBMS_AQELM
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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
 
GET_TXTIMEOUT
Returns the email timeout value: The default is 30000 dbms_aqelm.get_txtimeout(timeout OUT NUMBER);
DECLARE
 tOut NUMBER;
BEGIN
  dbms_aqelm.get_txtimeout(tOut);
  dbms_output.put_line(TO_CHAR(tOut));
END;
/
 
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_AQINV
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_AQ_IMP_ZECURITY
Packages
UTL_MAIL
UTL_MAIL_INTERNAL
UTL_SMTP
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved