Skip to Content.
Sympa Menu

freetds - Stored Procedure Return value Parameter binding

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Jason Luros" <jluros AT hotmail.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Stored Procedure Return value Parameter binding
  • Date: Thu, 27 Jun 2002 14:16:45 -0400


Can anybody guess as to when output parameter binding will be supported
with FreeTDS? I've got a Linux box running FreeTDS 0.53, DBI-1.21,
DBD::ODBC 0.39, and PERL 5.6.0. We're connecting to an MSSQL Database
running TDS Protocol version 7.0 and have been so far unsuccessful in
executing a sproc of the form:

my $trigger_messenger = $dbh->prepare(qq[
declare \@mydate datetime,
\@exitcode int
select \@mydate=getdate(),@\exitcode=5
exec \@exitcode = exec QLYS_jl_wrap_return
1,'jluros\@someaddress.org]);
$trigger_messenger->execute() || $dbh->errstr;
print "$exitcode\n";
$trigger_messenger->finish;

What I want to do is to get @exitcode out and store it as $exitcode / bind
it as something. However, the O'reilly book says in it's Appendix B
(Driver Characteristics) that DBD::ODBC doesn't yet support "out" paramter
binding. However, this book is from 02/2000, so this issue could be fixed
by now.

Thanks alot,
Jason Luros




Archive powered by MHonArc 2.6.24.

Top of Page