use Sybase::Simple;

my $dbh = new Sybase::Simple $user, $pwd, $server;

my $data = $dbh->ArrayOfHash("exec my_stored_proc");
# $data is an arrayref, where each row is a row from the proc.
# This will also cleanly handle multiple result sets from 
# the same proc.