From: Pit Capitain <pit@...>
Date: 2006-11-18T23:50:21+09:00
Subject: Re: How to pass arrays in and/or out of Oracle PL/SQL Package using OCI8

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