in reply to DBI execute_array

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.