bz_email_notif.sql

来自「oracle9i+j2ee开发aq oracle9i+j2ee开发aq or」· SQL 代码 · 共 33 行

REM script name: bz_email_notif.sql
REM This script adds an email notification for subscriber URGENT 
REM
REM version: 9i

REM =======================================================
REM Add email notification for subscriber 'URGENT' to BZCARDORDERS_Q
REM =======================================================


REM =======================================================
REM Set the mailserver properties
REM =======================================================
call sys.dbms_aqelm.set_mailhost('gmsmtp01.oraclecorp.com');
call sys.dbms_aqelm.set_mailport(25);
call sys.dbms_aqelm.set_sendfrom('[e-mail]');

REM =======================================================
REM Register for email notifications
REM =======================================================

declare
  reginfolist	sys.aq$_reg_info_list;
begin
  reginfolist 	:= sys.aq$_reg_info_list(
			sys.aq$_reg_info('bz_adm.bzcardorders_q:URGENT',
			   DBMS_AQ.NAMESPACE_AQ,
			   'mailto://[e-mail]', 
				null));
  dbms_aq.register(reginfolist, 1);
end;
/