try one of the $dbh-select(all|row)_arrayref, this does a prepare & execute
for you. Do a 'perldoc DBI' to read about them.
you have several options:
1 - $dbh->do
2 - $dbh->selectall_arrayref or $dbh->selectall_hashref
3- i don't think execute returns a statement handle.. no I just checked
it doesn't
so $dbh->prepare($sql)->execute; will work but you can't call finish
in the chain.
4 - why don't you read the DBI
Hi all,
For DBI wirh Oracle, instead of typing:
$sth = $dbh->prepare($sql_statement)
$sth->execute();
$sth->finish;
Can I write
$sth = $dbh->prepare($sql_statement)->execute->finish;