> > ... have an Oracle extension to use a cursor to select multiple
> > rows into variables declared as arrays. Have you run into this syntax or
> > thought about what it would take to implement it?
> Do you mean like this:
> exec sql begin declare section;
> int amount[6];
> char name[6][8];
> exec sql end declare section;
> ...
> exec sql select * into :name, :amount from "Test";
No (although I was not aware that the above would work). The example
looks like
exec sql begin declare section; char *name_arr[10];
exec sql end declare section;
exec sql declare names cursor for select name from horses;
strcpy(msg, "open");
exec sql open names;
exec sql fetch names into :name_arr;
exec sql close names;
So the syntax uses a cursor fetching into an array, rather than a
"select into". A couple of details on behavior from the Oracle docs:
Each FETCH returns, at most, the number of rows in the array
dimension. Fewer rows are returned in the following cases: <snip cases> The cumulative number of rows returned can be
foundin the third
element of sqlerrd in the SQLCA, called sqlerrd[2] in this guide.
The Oracle docs at the following URL are consistant with the examples I
was seeing:
http://www-rohan.sdsu.edu/doc/oracle/server803/A54661_01/arr.htm#512
I'm guessing that this is a relatively short hop from your existing
array capabilities, but don't how close. What do you think?
- Thomas
