DBI DBD::Oracle help

DBI DBD::Oracle help

am 25.01.2006 18:35:38 von nateshkedlaya

Hi,
How can I bind an Perl array to a PL/SQL function's
input/output that take PL/SQL associative arrays?

For Example;
In the following PL/SQL function:

function my_func
( p_1 in my_coll
, r_1 out my_coll
) return pls_integer;

The "my_coll" is a PL/SQL associative array having
the
following signature;
type my_coll is table of varchar2(10) index by
pls_integer;

Through OCI I can bind the native C array to PL/SQL
associative array directly without any extra
marshaling of the native C array.

How can I achieve the same using the DBI?
Appriciate any help on the topic.

Thanks,
Natesh

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com