FreeTDS Development Group

["Brian Bruns" <camber AT ais.org>]

Jason,

This is probably post-0.60 material.  I'll add it to the TODO list to make
sure we revisit it.  If someone were to figure out the call sequence
DBD::ODBC is using to retrieve this info and make a unittest (in C) out of
it, it would most likely result in a pretty quick fix.

Brian

> 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