You need to look at odbc_more_results. You need to call it to skip to the next result-set. You also need to call it until it returns false to guarantee getting output parameters. See Connecting Perl on UNIX or Linux to Microsoft SQL Server - Perl DBI/DBD::ODBC Tutorial Part 3 which has examples of procedures returning multiple result sets under "Procedures Generating Multiple Result-Sets".