The following code segment works on my Oracle 9.2 setup
# table books - title char(10)
my $dbh;
connectdb(); # sets $dbh use your connection here, I have AutoCommit=
+>0
my $sth = $dbh->prepare("insert into books values (?)");
my @val = qw(one two three four five);
$sth->bind_param_array(1,\@val);
my $tuples = $sth->execute_array({ArrayTupleStatus=>\my @tuple_status}
+);
print "Tuples = $tuples\n";
$dbh->commit();
$dbh->disconnect();
sub connectdb {
$dbh = DBI->connect();
}
Running this gives
Tuples = 5
sqlplus user/pass
SQL> select * from books
TITLE
-----------
one
two
three
four
five
I think I have typed the code OK, different machine to terminal attached to Unix/Oracle.