On 28-Jun-2002 Simon Oliver wrote: > Jason Luros wrote: >> >> 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: >> > > DBD::ODBC does not support "out" variable binding.
Yes it does - I use it. See mytest/*.pl for examples in the DBD::ODBC distribution. However, I don't think FreeTDS supports output bound parameters. > Construct your stored procedure to return a result set instead - end your > SQL by SELECTing the desired variable. You can get the result by binding > a variable to column 1 and calling $h->fetch or using $h->fetchrow_array > in a scalar context. Fair enough. Martin -- Martin J. Evans Easysoft Ltd, UK Development
