OPEN t_count FOR
SELECT A.name,
A.code,
A.info FROM t_table A;
LOOP
FETCH t_count INTO t_name,t_code,t_info;
SMSCONTENT := t_name || '您好!,你有' ||t_info||
',请尽快处理!';
--给序列号赋值
SELECT TO_CHAR(SYSDATE, 'yyyymmdd') || SEQ_SMSSEND_ID.NEXTVAL
INTO SMSNOTICEID
FROM DUAL;
INSERT INTO TI_TDEAL
(SMS_NOTICE_ID,
SP_SVC_ID,
SMS_CONTENT,
)
VALUES
(SMSNOTICEID,
t_code,
SMSCONTENT);
COMMIT;
EXIT WHEN T_BILL%NOTFOUND;
END LOOP;
CLOSE T_BILL;为什么我用游标从A表里数据插入B表 A表最后一条记录都会插B表中2遍
求怎么解决
SELECT A.name,
A.code,
A.info FROM t_table A;
LOOP
FETCH t_count
EXIT WHEN T_BILL%NOTFOUND;
INTO t_name,t_code,t_info;
SMSCONTENT := t_name || '您好!,你有' ||t_info||
',请尽快处理!';
--给序列号赋值
SELECT TO_CHAR(SYSDATE, 'yyyymmdd') || SEQ_SMSSEND_ID.NEXTVAL
INTO SMSNOTICEID
FROM DUAL;
INSERT INTO TI_TDEAL
(SMS_NOTICE_ID,
SP_SVC_ID,
SMS_CONTENT,
)
VALUES
(SMSNOTICEID,
t_code,
SMSCONTENT);
COMMIT;
END LOOP;
CLOSE T_BILL;