results are not retrieved if temp tables are used in stored procedure not

Dear All
I have created a stored procedure which first creates an temporary table, insert the values and queries it. This works perfectly in MSSQL management studio, but when i try to execute the same procedure using php, it does not returns any rows.

I am using PEAR DB and MSSQL 2005


$sql="Exec up_parmsel_inspectionreportstatus_dashboard";
$data_arr = $db->getAll($sql, DB_FETCHMODE_ASSOC);
print_r ($data_arr);

Whats going wrong?

Thanks

Please help me out. or suggest a different solution.