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. 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. HIH -- Simon Oliver
