in reply to Re: Multiple records fetches issue using DBD::ODBC in Perl
in thread Multiple records fetches issue using DBD::ODBC in Perl
I have set DBI TRACE=1 and executed the code.
my $result = $sql->execute() or die "Couldn't execute statement: " . $sql->errstr;after sql->execute it prints the value as -1.
Actually, I am doing perl upgrade, The existing code has used MSSQL::DBLIB,MSSQL::SQLLIB to execute the stored procedures (MS SQL SERVER)which are deprecated in the higher version.For Windows platform i have used DBI,DBD::ODBC module to connect the Database and execute the stored procedure.
Note: Database connection and stored procedure execution was working fine in perl old version(20 yrs old)
|
|---|
In Section
Seekers of Perl Wisdom