FreeTDS Development Group

["Jason Luros" <jluros AT hotmail.com>]

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