Re: Fast inserts with ADO and Oracle
From: Mark Meyer <mmeyer_at_raytheon.com>
Date: Wed, 08 Nov 2000 11:02:16 -0600
Message-ID: <3A098718.D41E7BA1_at_raytheon.com>
Date: Wed, 08 Nov 2000 11:02:16 -0600
Message-ID: <3A098718.D41E7BA1_at_raytheon.com>
Nuno Souto wrote:
> ... I'd rather use something more direct. You should be able to pass
> arrays to PL/SQL and have the procedure do an insert loop or even an
> array insert via dynamic sql. That will definitely be fatser than
> multiple calls to the overhead of ADO. ...
How do you pass an array from Visual Basic or Active Server Pages to PL/SQL?
-- Mark Meyer mmeyer_at_raytheon.com Raytheon Systems Company Voice (972)575-4595 Fax (972)575-5544Received on Wed Nov 08 2000 - 18:02:16 CET