oracle存储过程使用的小例子

 create or replace procedure liujiatemp (
  mymsisdn in number
  )
as
   money cms3_simcard.card_fee%type :=0;
   cursor mycursor is
          select * from cms3_simcard
          where return_flag = 1 and msisdn like '%'||mymsisdn||'%';
   my_record mycursor%rowtype;
   Counter int :=0;
  
begin
   open mycursor;
   if mycursor%isopen  then 
   loop
     fetch mycursor into my_record;
         if mycursor%found then 
            dbms_output.put_line(my_record.card_fee);
         else
            exit;
         end if;
   end loop;
   else
     dbms_output.put_line('游标没有打开');
   end if;
  close mycursor;
end;