$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); #### $VAR1 = { 'Beginning_Date' => '2011-03-27', 'Ending_Date' => '2011-04-02', '\'FD622\'' => 'FD622' };