freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
return value from stored procedure,
Seo, 06/14/2001
- <Possible follow-up(s)>
- Re: return value from stored procedure, Darryl Friesen, 06/14/2001
- Re: return value from stored procedure, Steve Langasek, 06/14/2001
- Re: return value from stored procedure, Michael Peppler, 06/14/2001
Archive powered by MHonArc 2.6.24.