$refStr = "call crchampsview.FD622_Determine_Date_Range_SP( '2011-04-01' )"; 
$sth = $dbh->prepare($refStr);
$sth->execute; 
$row = $sth->fetchrow_hashref;
$sth->finish;
print Dumper($row);