Skip to Content.
Sympa Menu

freetds - Re: return value from stored procedure

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Steve Langasek <vorlon AT netexpress.net>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: return value from stored procedure
  • Date: Thu, 14 Jun 2001 09:03:57 -0500 (CDT)


On Thu, 14 Jun 2001, Darryl Friesen wrote:

> > This is my stored procedure with a 10001 return code.

> [snip]

> > So, How can i get it from Perl ?
> > ---------------------------------------
> > use DBI;
> > my $dbh = DBI->connect("dbi:Sybase:server=server", 'usr', 'pwd',
> > {PrintError => 0});

> > $sth = $dbh->prepare("EXEC foo");

> Maybe you've left it out of your example, or maybe stored procedures work
> differently (I don't think so), but you're missing the execute statement
> after the prepare.

> $sth->execute();

> Having said that, I've never used stored procedures from Perl, so I can't
> say whether or not that's all you need to do, or even if they work at all.

I have used stored procedures from Perl, and haven't had any problems with
them: 'prepare' and 'execute' is all I've ever had to do.

Cheers,
Steve Langasek
postmodern programmer





Archive powered by MHonArc 2.6.24.

Top of Page