my $sth=prepare->('call my_sp($some_number);');
$sth->execute();
my $foo=$sth->fetchall_arrayref();
$sth->more_results();
my $bar=$sth->fetchall_arrayref();
$sth->more_results();
my $baz=$sth->fetchall_arrayref();