Oracle有参数带返回值的存储过程简单例子：

create or replace procedure caf_trackdiffbyId(
       sendid in number,
       userid in varchar ,
       diffnum in number,
       lats in number,
       latn in number,
       lngw in number,
       lnge in number,
       minid out number ,
       maxid out number
) is
currDate date;
minDate date;
maxDate date;
subMin number;

Cursor baseMinCursor is select * from caf_usertrack where datetimecurrDate order by id asc ;

begin
  select datetime into currDate from  caf_usertrack where id=sendid and userid=userid and
 lat >= lats and lat = lngw and lng