求教学oracle存储过程的写法，谢谢，需要详解

2024-12-22 20:22:27

推荐回答（1个）

回答1：

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;