Using the DBI with Microsoft SQL Server, I'm trying to get data back
from a stored procedure call and getting an "Invalid Cursor State"
error at the execute() call below (it never gets to the
fetchrow_array call). Has anyone else run into this? Can anyone help?
my $sth = $dbh->prepare("exec sp_helpdb");
my $rv = $sth->execute();
my($dbname,$size,$owner) = $sth->fetchrow_array();
while ($dbname) {
.....
($dbname,$size,$owner) = $sth->fetchrow_array();
}
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
