Re: Varrays with ODBC

"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.

However, VARRAY and ODBC = 1 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.

(Sorry for the late reply, I've been away.)

Not really IMO.

For instance on my machine the microsoft odbc driver doesn't support stored procedures whereas the oracle one does.

Is perhaps a 'good' way to manipulate Varrays though ODBC with stored procedures given the nature of the object?

I don't know, which is why I started this thread. Received on Tue Jun 08 2004 - 08:47:29 CDT