Re: Yet Another Stored Procedure Question

[one4k4]

The replies above are great, but I wanted to show you some psuedo code for what I do when executing Stored Procs on Sybase. Mind you, this is untested and straight from the fingertips..

my $sth->prepare("exec DBname..stored_proc_name ?,?");
$sth->execute($var1,'var2');

while ($sth->fetchrow_hashref){.....
...
}

And in the SP, according to what it sounds like you're doing.

..spcode..
declare @var int
select @var = 42

select @var as var_name_for_hash
end
..endofsp..

The last select statement will be returned to the calling Perl code. And simply running select @var=42 might not do it.. so I used the @var as .. moniker. I don't now, maybe I'm misreading your post and if I am, let me know! :)

I hope this helps.

P.S. Why would binding an output value be used? Isn't "output value" really "whatever the SP returns.. list of employees, paychecks, candy bar names"?

One4k4 - [e-mail] (www.poorheart.com)