Hi,
I had been trying to call mysql stored procedure, but not able to do
it successfully.
The usage and error that i received are as follows:
*************************************************
Usage:
my $sth=$dbh->prepare(qq{call getme()});
$sth->execute() or die("SQL Error:- $DBI::errstr\n");
Error:
DBD::mysql::st execute failed: PROCEDURE test.getme can't return a
result set in the given context at line 11.
*************************************************
It'll be great if you could pls. guide me how to do that.
Thanks and Regards,
Vinod