I am having a SP with nested Cursors. The SP is called inside a Perl script.
While running the Perl script for the first time the SP is exiting with error:
The SP runs fine when attempted twice/thrice.
Could anyone please provide me some inputs?
This is probably a driver level bug. Without seeing the source - either to your Perl script neither to the underlying ODBC layer, it's difficult to tell. However, from my experience of ODBC, there isn't any requirement to call anything in between SQLExecute / SQLExecDirect and SQLFetch - so I'm not sure what the issue is.
Sorry to not be much help.
answered Jun 09 '10 at 04:19 AM
Matt Whitfield ♦♦