存储过程- insert

create or replace procedure injectDevice is
  
  v_counter NUMBER DEFAULT 0;   
  
begin
   dbms_output.put_line('begin insert ');
  
  FOR v_counter in 0..800000  LOOP
     
   BEGIN
        

..............
                                                                         to_date('2009-10-16 13:35:14','YYYY-MM-DD HH24:MI:SS'),                                                                                                                                   .............                
   
    
    EXCEPTION
      WHEN OTHERS THEN       
        dbms_output.put_line(v_counter ||'error');
    END;   
     
  END LOOP  ;
 
  COMMIT;
 
      
      
  --报告
   dbms_output.put_line('----------------------------------------');
   dbms_output.put_line('插入记录数:'||v_counter||'条');
  
EXCEPTION
      WHEN OTHERS THEN
        dbms_output.put_line('程序异常');
         
end injectDevice;

------------------------------------------------

begin
  -- Call the procedure
  injectdevice;
end;