Skip to Content.
Sympa Menu

freetds - Re: Stored Procedure Return value Parameter binding

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Brian Bruns" <camber AT ais.org>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: Stored Procedure Return value Parameter binding
  • Date: Fri, 28 Jun 2002 09:24:42 -0400


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




Archive powered by MHonArc 2.6.24.

Top of Page