Re^2: Retrieving a result from a MS SQL Stored Procedure using DBI and ADO under Win32 Perl

Yes setting "SET NOCOUNT ON" in SP is worked and it produced all my data but at the end it showing an error:

0 rows (1: no select statement currently executing (SQL-HY000))
DBD::ODBC::st dump_results failed: no select statement currently execu
+ting (SQL-
HY000) at line
[download]

Comment on Re^2: Retrieving a result from a MS SQL Stored Procedure using DBI and ADO under Win32 Perl Download Code

Replies are listed 'Best First'.
Re^3: Retrieving a result from a MS SQL Stored Procedure using DBI and ADO under Win32 Perl by xlatd7 (Initiate) on Aug 05, 2018 at 17:59 UTC
Thanks for sharing, i've got the same issue, and you can prepend SET NOCOUNT ON to your exec statement if you cannot modify the stored procedure.	[reply]
Re^3: Retrieving a result from a MS SQL Stored Procedure using DBI and ADO under Win32 Perl by Anonymous Monk on Aug 18, 2016 at 04:50 UTC
Issue resolved...used for loop instead of while for dump_results	[reply]