Binding perl arrays to PL/SQL arrays

[Steven Baldwin]

Hi there,

Is it possible to do something like this (I know the code I have here won't
work) ...

$anon_plsql = $dbh -> prepare (q (
    DECLARE
        l_idx           PLS_INTEGER := 0 ;
    BEGIN
        FOR i IN 1 .. 10 LOOP
            :arr (l_idx) := 'Hello ' || i ;
        END LOOP ;
    END ;
    )) ;
@arr = () ;
$anon_plsql -> bind_param (":arr", \@arr) ;
$anon_plsql -> execute ;

Thanks for your help,

Steve