procedure qxyh

CREATE OR REPLACE   procedure qxyh(
   aa in varchar,
  )
is
vstr varchar2(250);
vusernumber varchar2(30);
cursor  get_usernumberxlt_tel  is
       select usernumber  from  usertailor where status<>1;;
begin
       for  get_usernumberxlt_tel_record  in get_usernumberxlt_tel  loop
        if aa=1 then
            vstr:='2003 '||get_usernumberxlt_tel_record.usernumber;
            Sms.procCreateSmsCT(1185566,1188888,1188888,vstr,0);
        else
           sms.procCreateSmsCM30('',get_usernumberxlt_tel_record.usernumber,get_usernumberxlt_tel_record.usernumber,aa,1001,'');
        end if;
       end loop;
end ;
/

grant execute on  to ;

game.pro_smswebzfsms(aa)   er