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.
[download]

You can of course do the same thing with DBI/DBD::Sybase, but I've not verified that the fetchall_*() routines actually fetch multiple result sets for you.

Michael