Re: How to retrieve output parameter from stored procedure?

[Steve Porter]

I finally figured it out. I modified the code as follows:

use DBI;

my $hDb = DBI->connect( 'dbi:mysql:dictionary',
'root',
'pass123',
) || die "Database connection not made: $DBI::errstr";
print "connected\n";

# see if the stored procedure will work
my $nSenseId;
my $strMsg;
$hDb->do( "call CreateDictionaryEntry( 7,'junk46', 'N', \@nSenseId, \@strMsg );" );
$nSenseId = $hDb->selectrow_array("SELECT \@nSenseId");
$strMsg = $hDb->selectrow_array("SELECT \@strMsg");

$hDb->disconnect();

exit;

The backslashes are needed in front of the @.

Steve