Re^3: ODBC Error - Invalid Cursor State (SQL-24000)

I also saw this using FreeTDS. It was while reading through a result set in a while loop. My stored proc returned two sets of data (2 SELECTs). When I fit all of the data into a single SELECT that particular error went away.

Comment on Re^3: ODBC Error - Invalid Cursor State (SQL-24000)

Replies are listed 'Best First'.
Re^4: ODBC Error - Invalid Cursor State (SQL-24000) by mje (Curate) on Mar 21, 2011 at 10:16 UTC
You need to look at odbc_more_results. You need to call it to skip to the next result-set. You also need to call it until it returns false to guarantee getting output parameters. See Connecting Perl on UNIX or Linux to Microsoft SQL Server - Perl DBI/DBD::ODBC Tutorial Part 3 which has examples of procedures returning multiple result sets under "Procedures Generating Multiple Result-Sets".	[reply]