Skip to Content.
Sympa Menu

freetds - [freetds] Invalid Cursor state

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: <jezekj AT centrum.cz>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Invalid Cursor state
  • Date: Thu, 28 Jan 2016 20:51:01 +0100

Hello,
 
first of all I would like to thank you for creating and maintaining FreeTDS.
In our application we do have procedure to trace progress of huge procedures
execution to easily find out where the error is. This procedure contains
raiserror function. When in another procedure I call select after trace
procedure is called out I got invalid cursor state. i.e.:
 
create procedure sp_trace as
  raiserror('test', 0, 1)
go
 
create procedure sp_test_me as
  select getdate()
  execute sp_trace
  select getdate()
go
 
Then we call out from perl:
my $dbh=APPDBI->masterConnect();
my $statement='execute sp_test_me';
my $sth=$dbh->prepare($statement);
my $sth->execute;
while (my $d=$sth->fetch;){ #get 1st result set (first getdate)
  print Dumper $d;
}
while (my $d=$sth->fetch;){ #get 2nd result set (second getdate)
  print Dumper $d;
}
 
 
Can you confirm this is a bug which can/will be fixed?
We have tried other driver in our setup (easysoft) and it is not case.
Please let me know wah other details you need from me to support you in
investigation.
 
Best Regards,
JJ




Archive powered by MHonArc 2.6.24.

Top of Page