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)