Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: DBI execute_array

by tweetiepooh (Hermit)
on Feb 11, 2009 at 17:37 UTC ( [id://743118]=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://743118]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others about the Monastery: (5)
As of 2024-04-18 19:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found