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 DBA/Programmer Qualys, Inc. (650) 801-6125 [EMAIL PROTECTED]
