Re: ADO and Oracle PL/SQL Table

From: Ross McKay (rosko_at_zeta.NOT.THIS.BIT.org.au)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 05:01:34 GMT

On Tue, 22 Jun 2004 09:22:13 -0700, "Pengguang Wu" wrote:

>Does anyone know whether you can fill an Oracle PL/SQL table using ADO in
>VB/VBA for updating an Oracle database? We have a commercial app that
>exposes a function with several PL/SQL tables as input parameters. Any
>suggestion to use this type of function is appreciated. Thanks,

AFAIK, ADO does not support table types. Perhaps you could write some
wrapper stored procedures to let you populate a working table and then
call these functions. 

-- 
"There is more to life than simply increasing its speed." - Mahatma Gandhi