短信:
insert into MBSSendMsg
(Sender, Recipient, MsgLevel, MsgType, Subject, URLs, MMSInfo, MsgStatus, MsgSize, SendStyle, SendTime, SendOutTime, DeliverTime, ScreenHeight, ScreenWidth, ComPort, MsgID, RefID, ExtendInfo, Comments)
Values
('13999998888', '13988889999', 0, '1', '文字短信测试消息', ' ', ' ', '0', 8, 0, ' ', ' ', ' ', 200, 140, 0, '20080101000002', ' ', ' ', ' ')
批量发送测试:
declare
i number;
begin
i:=202196521;
while i<=202196551 loop
insert into SCOTT.MBSSendMsg
(Recipient, MsgLevel, MsgType, Subject, MsgStatus, MsgSize, SendStyle, ComPort, NeedFeedBack, NeedReadFeedBack, MsgID)
values
('10086', 0, 1,'XYZ', 0, 0, 0, 0, 1, 0,i);
i:=i+1;
end loop;
COMMIT;
end;
彩信:
insert into MBSSendMsg
(Sender, Recipient, MsgLevel, MsgType, Subject, URLs, MMSInfo, MsgStatus, MsgSize, SendStyle, SendTime, SendOutTime, DeliverTime, ScreenHeight, ScreenWidth, ComPort, MsgID, RefID, ExtendInfo, Comments)
Values
('13999998888', '13988889999', 0, 512, '彩信测试-注意图片的路径是真实有效的', ' ', 'C:\mms_model.jpg', '0', 8, 0, ' ', ' ', ' ', 200, 140, 0, '20080101000003', ' ', ' ', ' ')
- 1
- 2
- 3
前往页