oracle 存储过程实例

create or replace
procedure test_paramout_01(staff_id_str in VARCHAR2,ticket_seq_str in number,schedule_date_str in VARCHAR2)
 is
   begin
   update twf_tech_schedule tts set  ticket_seq = (ticket_seq+1)  where tts.staff_id=staff_id_str  and tts.ticket_seq>=ticket_seq_str and tts.schedule_date>=to_date(schedule_date_str,'yyyy-mm-dd');
 END;

　　

create or replace
procedure test_paramout_01(staff_id_str in VARCHAR2,ticket_seq_str in number,schedule_date_str in VARCHAR2)
 is
   begin
     for emm in(select tts.work_item,tts.ticket_seq from twf_tech_schedule tts where tts.staff_id=staff_id_str  and tts.ticket_seq>=ticket_seq_str and tts.schedule_date>=to_date(schedule_date_str,'yyyy-mm-dd')) loop              
      update twf_tech_schedule set  ticket_seq = (ticket_seq+1) where work_item = emm.work_item;
     dbms_output.put_line(emm.ticket_seq);
    end loop;
 END;