From: teh@nospam.com   
      
   I have the following procedure:   
      
      TYPE testarray is table of int index by binary_integer;   
      
      PROCEDURE testfast(par1 in testarray) is   
      begin   
        FORALL i IN par1.FIRST..par1.LAST   
          insert into dummy (test) values (par1(i));   
      end;   
      
   This works, but is not a good solution with giant arrays, as the forall   
   puts all of it in memory. The obvious solution would be to use BULK   
   COLLECT and a LIMIT, but that only works with SQL types, and not with   
   PL/SQL collections, as far as I can tell.   
      
   Somewhat oddly, if I call the insert statement directly from my client   
   using array binding, the perfomance is as good as the procedure and it   
   scales well with large arrays.   
      
   I would think it should be possible to achieve the same performance and   
   scalability via a procedure, right?   
      
   I have to use an associative array, because that's the only collection   
   type currently supported by ODP.NET, unless I'm mistaken.   
      
   --   
   Tor H.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)