How to call 'Select' MySQL Procedures from Perl

[sainandoor]

Hi Folks,
I am trying to call a "select" stored procedure from perl. I am not quite sure how to do it. Here is the stored procedure:

CREATE PROCEDURE spTest() begin select x AS X from tblTest;

It works fine when called from within MySQL.

mysql> call spTest():
+------+
| X |
+------+
| 24 |
| 3 |
+------+

I have the following code in perl:

my $spt = $db->prepare("Call spTest()");
$spt->execute();
$spt->bind_columns(\$id);
while($spt->fetchrow_array()){
print "X = $id";
}

I get an error that says I need to use "select into". How do I call this procedure from perl?