Re: Varrays with ODBC

From: anacedent <anacedent_at_hotmail.com>
Date: Sun, 06 Jun 2004 11:59:49 -0700
Message-ID: <GQJwc.50942$oi5.8783@fed1read07>

Alfie wrote:

> Hi,
>
> After advice from this forum I'm trying to implement a simple VARRAY object
> structure.
>
> However, I'm working with ODBC and MSVC++ and I can't work out how to do so.
>
> Obviously I need to insert and query the "object".
>
> How can this be done with ODBC given there are multiple rows for the array?
>
> I've had a look but can't find any on-line examples.
>
> For instance, do I have to do a separate insert for each row of the varray,
> or is there a nicer way to insert/query all at once?
>
> Would someone be good enough to advise, post a reference, or best of all a
> couple of code snippets?
>
> Thanks

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) Received on Sun Jun 06 2004 - 13:59:49 CDT