Sorry guys,

The " # => 'st(1) = array 1, st(2) = array 2' " is my comment about
what I expect to get...  The code doesn't execute.  The real problem is
that I don't understand how to code the define_param correctly for
arrays.

Thanks,
Jason

On Nov 18, 8:50 am, Pit Capitain <p... / capitain.de> wrote:
> Jason Vogel schrieb:
>
> > ...
> >     st(1) := 'array 1';
> >     st(2) := 'array 2';
> > ...
> > cursor.bind_param(':out_array', StringArray?)
> > ...
> > p cursor[':out_array'] # => 'st(1) = array 1, st(2) = array 2'
>
> > I can't figure how what it takes to get the arrays to work.Jason, doesn't the output look right to you? The two strings of the
> string array seem to be present. Note that you print the whole array. If
> you like one element of the array, try
>
>    p cursor[':out_array'][1]
>
> I'm just guessing, but maybe this helps. You could also look at the
> class of the array and at the methods it supports:
>
>    p cursor[':out_array'].class
>    p cursor[':out_array'].methods.sort
> 
> Regards,
> Pit