I'm having problems opening a transaction through perl DBI
When I try to execute "begin work" using the DBI prepare and execute
functions I get an error:
$sth = $dbh->prepare("begin work");
$sth->execute();
returns this error when I run the perl script from a prompt:
please use DBI functions for transaction handling at
/usr/lib/perl5/site_perl/5.
005/i386-linux/DBD/Pg.pm line 114, <STDIN> chunk 2.
Can't call method "execute" on an undefined value
after seeing this I assumed that you just can't use the begin statement
accross the DBI but there has to be a way of opening a transaction (it even
says so in the error I got) ... I'm just not sure how.
can someone please shed some light on this... I've looked through the
archives but didn't find anything constructive.
Thanks
Scott