in reply to Howto fetch procedure return value

Here's something that you might want to look into...(bind_columns). It binds columns to variable names.

$select = $db->prepare($sql);
$select->execute();
$select->bind_columns(undef,\$var1,\$var2);
while ($select->fetch)
{
print "$var1 $var2\n";
}

[download]

--JD

In Section Seekers of Perl Wisdom