Re: Pro*C host arrays: how big?

Kevin Neel (k-neel_at_nwu.edu) wrote:
> Actually, you CAN use dynamically-sized arrays, by declaring your
> variables as pointers and using the FOR clause of embedded SQL.

Yes, I found this out: last week the bloke on the Oracle-uk helpdesk denied this, so I tried it, and found it worked. This week, they think about it a bit, and agree with me.
NB. Programmer's Guide to the Precompilers V. 1.4 page 7-12 reads "The number of array elements processed is determined by comparing the dimension of the /smallest/ host or indicator array with the FOR-clause variable. The lesser value is used."

Apparently, in V. 1.5, this reads as "Ensure that the FOR-clause variable is no bigger than the smallest host or indicator array".

> However, Oracle does not (or at least did not in the past) understand
> arrays of structures. In fact, it doesn
> structures at all. You can use several arrays of scalars.
Which is what I'm doing, and then copying the data.

I'm trying to work out how to tell it that the array elements are the bigger than they really are, so that I can interleave them and make Oracle see my array of structures as a set of arrays.

> In general, I think Simon
> The copying within your program usually isn
> prefer to use structures).

Beg pardon?

--
  _________________________   __________________________________________
 /  Tommy Wareing          \ /  In the beginning, there was The Bomb    \
|  p0070621_at_brookes.ac.uk   X   And The Bomb said "Let there be Light!"  |
 \  0865-483389            / \     - The Bomb, Dark Star                /
  ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~