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 docs? they are available on your system
you are running DBI on. try typing man DBI or perldoc DBI or visit
http://kobesearch.cpan.org to read them
On Sunday, November 4, 2001, at 05:16 PM, Stacy Mader wrote:
>
> 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;
>
