FreeTDS Development Group

[Steve Langasek <vorlon AT netexpress.net>]

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