請問題各位為什么oracle會重復發兩次相同的mail,目前沒找出具體原因。請各位大俠幫忙分析分析。
CREATE OR REPLACE PROCEDURE overtime_alert
IS
strhtml VARCHAR2 (32760) := '';
conn UTL_SMTP.connection;
thistime DATE;
BEGIN
IF SYSDATE >=
TO_DATE (TO_CHAR (SYSDATE, 'YYYY/MM/DD') || ' 08:30',
'YYYY/MM/DD HH24:MI'
)
AND SYSDATE <
TO_DATE (TO_CHAR (SYSDATE, 'YYYYMMDD') || '1800',
'YYYYMMDDHH24MI')
THEN
--IF SYSDATE >= TO_DATE(TO_CHAR(SYSDATE,'YYYY/MM/DD')||' 08:30','YYYY/MM/DD HH24:MI') AND SYSDATE < TO_DATE(TO_CHAR(SYSDATE,'YYYYMMDD')||'2030','YYYYMMDDHH24MI') THEN
DECLARE
sn VARCHAR2 (60);
partno VARCHAR2 (50);
sublinename VARCHAR2 (50);
sitename VARCHAR2 (50);
defectcode VARCHAR2 (50);
status NUMBER;
createtime DATE;
countsn NUMBER := 0;
countmail NUMBER := 1;
starttime DATE;
endtime DATE;
--Μン
to_mail VARCHAR2 (1000)
:= 'E-MAIL地址'; CURSOR selectcursor1
IS
SELECT c.subline_name, c.site_name, a.sn, b.part_no, a.status,
a.TIME
FROM uw_runcard a, uw_wo b, uw_site_view c
WHERE b.order_type != 'ZTR'
AND a.wo_key = b.wo_key
AND a.current_site = c.ws_id
AND b.classification = 101
AND a.TIME + 2 / 24 < SYSDATE
AND a.status IN (2, 18, 20)
AND a.TIME >
TO_DATE (TO_CHAR (SYSDATE, 'YYYY/MM/DD') || ' 08:30',
'YYYY/MM/DD HH24:MI'
)
ORDER BY c.subline_name;
CREATE OR REPLACE PROCEDURE overtime_alert
IS
strhtml VARCHAR2 (32760) := '';
conn UTL_SMTP.connection;
thistime DATE;
BEGIN
IF SYSDATE >=
TO_DATE (TO_CHAR (SYSDATE, 'YYYY/MM/DD') || ' 08:30',
'YYYY/MM/DD HH24:MI'
)
AND SYSDATE <
TO_DATE (TO_CHAR (SYSDATE, 'YYYYMMDD') || '1800',
'YYYYMMDDHH24MI')
THEN
--IF SYSDATE >= TO_DATE(TO_CHAR(SYSDATE,'YYYY/MM/DD')||' 08:30','YYYY/MM/DD HH24:MI') AND SYSDATE < TO_DATE(TO_CHAR(SYSDATE,'YYYYMMDD')||'2030','YYYYMMDDHH24MI') THEN
DECLARE
sn VARCHAR2 (60);
partno VARCHAR2 (50);
sublinename VARCHAR2 (50);
sitename VARCHAR2 (50);
defectcode VARCHAR2 (50);
status NUMBER;
createtime DATE;
countsn NUMBER := 0;
countmail NUMBER := 1;
starttime DATE;
endtime DATE;
--Μン
to_mail VARCHAR2 (1000)
:= 'E-MAIL地址'; CURSOR selectcursor1
IS
SELECT c.subline_name, c.site_name, a.sn, b.part_no, a.status,
a.TIME
FROM uw_runcard a, uw_wo b, uw_site_view c
WHERE b.order_type != 'ZTR'
AND a.wo_key = b.wo_key
AND a.current_site = c.ws_id
AND b.classification = 101
AND a.TIME + 2 / 24 < SYSDATE
AND a.status IN (2, 18, 20)
AND a.TIME >
TO_DATE (TO_CHAR (SYSDATE, 'YYYY/MM/DD') || ' 08:30',
'YYYY/MM/DD HH24:MI'
)
ORDER BY c.subline_name;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货