CREATE or replace PROCEDURE fun_xsreMobile
(
paR_intInterID_c int,
paR_lngMobile_c number,
Date_c number
)
is
--定义变量
begin
Select ID,
CpID,
MobState,
Settled,
SendDate,
ReceCount,
IsLocked,
GateID,
ExtData,
ReceTs
--into 到变量
From xsreMobile
where InterID = paR_intInterID_c
and Mobile = paR_lngMobile_c
and SendDate >= Date_c
and rownum<=1;
end fun_xsreMobile;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024