Re: Multiple records fetches issue using DBD::ODBC in Perl

This problem might be related to a stored procedure as the statement to be executed. Is there a way to define a view that gives the same result and to use a select on this view to get the result set? Maybe this could help narrowing the problem.

Greetings,
-jo

$gryYup$d0ylprbpriprrYpkJl2xyl~rzg??P~5lp2hyl0p$

Comment on Re: Multiple records fetches issue using DBD::ODBC in Perl

Replies are listed 'Best First'.
Re^2: Multiple records fetches issue using DBD::ODBC in Perl by maria80e (Novice) on Apr 20, 2020 at 10:31 UTC
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)	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: Multiple records fetches issue using DBD::ODBC in Perl
by maria80e (Novice) on Apr 20, 2020 at 10:31 UTC

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)

[reply]
[d/l]