Re: Varrays with ODBC

You might want to try OO4O. I believe that is available in Oracle 8.1.7 http://www.doc.gold.ac.uk/oracle/doc/win.817/a85257/toc.htm

That allows you to do things like bulk inserts and also has a varray type in case you want to pass multiple rows to a pl/sql proc.

If it is Bulk Inserts you are looking to do then we did some testing here and the faster approach though not my much was OO4O's own built in bulk insert using the ParamArray object. That may work out different depending on the data sets you are using though.

Cheers,

Kevin

"anacedent" <anacedent_at_hotmail.com> wrote in message news:xoKwc.51013$oi5.6565_at_fed1read07...
> Alfie wrote:
>
> >>a very good place to find code examples is
> >>http://asktom.oracle.com
> >>also try
> >>http://otn.oracle.com
> >>(which requires a free signup & they don't spam folks who signup)
> >
> >
> > Yup, I've looked there but didn't find much.
> >
> > ALso i'm looking for advice on the *best* way to do it with ODBC.
> >
> > PS I'm using 8.1.7
> >
> > Thanks
>
> from ASKTOM:
> {varray} Approximately 151 records found.
>
> Why do you think that ODBC matters at all?
>
> ODBC simply provides the mechanism to connect to an RDBMS.
> You could just as well be using JDBC or BEQ.
> VARRAYS are VARRAYS regardless of how you got to the DB.
> What you do after the connection exists is up to you.
Received on Wed Jun 09 2004 - 04:29:56 CDT