Subject: | Selectrow_array() with prepared statement doesnt work |
calling more than one time selectrow_array for a prepared statement
throws error :
DBD::SQLite::db selectrow_array failed: not an error(21) at dbdimp.c
line 372
below is a sample script :
use DBI;
$dbh= DBI->connect("dbi:SQLite:dbname=./storage.db",undef,undef,{
RaiseError => 1, AutoCommit => 1 });
$sth_search_channel_in_standby = $dbh->prepare("select a from mytable
where value=?");
$dbh->selectrow_array($sth_search_channel_in_standby,undef,'TEST');
$dbh->selectrow_array($sth_search_channel_in_standby,undef,'TEST');