in reply to Re: MS SQL Stored Procedure Syntax
in thread MS SQL Stored Procedure Syntax
First, $! does not return error messages from DBI, you want $DBI::errstr instead (or RaiseError, see the next note).$dbh = DBI->connect("dbi:ODBC:CQmaster",$user,$password) || die "Can't + open! $!";
I doubt that'll magically fix anything, so after that, if the warning still occurs, you can try putting $sth->finish after one or both of the fetch loops, though it seems like it should be unnecessary (maybe it gets confused with a stored procedure?).
|
|---|