OCI and arrays of structures

Hi,
I just started learning programming with Oracle Call Interface, and got stuck with a pretty obvious thing, I can't manage to properly define array of structures.

I have:
SELECT something1 something1 something3 FROM something WHERE something4=whatever

and I have a structure defined:

typedef struct {

something1
something2
something3

}my_struct;

and an array:

my_struct *my_array[NUM];

Now how do I properly define members of my structure as an output variables for my select list?

I know I do this by calling OCIDefineByPos and OCIDefineArrayOfStruct, but do i define each element of my structure separately? What handler do I pass then to OCIDefineArrayOfStruct?

I will be really glad if you could help me work out this newbie question, or may be just forward me to the right place for documentation/advice.

Thanks a lot,
Art. Received on Sun Jan 07 2001 - 12:26:39 CET