Re: Varrays with ODBC

Hi,

Overnight I upgraded to 10g and am looking at OCCI now which seems to he a fair amount of documentation re VArrays etc.

Thanks anyway.

"Kevin Crosbie" <caoimhinocrosbai_at_yahoo.com> wrote in message news:d988bd1b09e81d6abf95e1671afdc0b3_at_news.teranews.com...
> 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 - 08:47:39 CDT